Did you do an RPM install of postgres? If so, make sure you have install the postgres 'devel' package.

Otherwise, you'll need to tell the Perl module where the postgres source can be found.

CC