perl and php connect problems to pgsql all of a sudden

On Tue, 7 Jun 2011 08:21:27 -0700, Shad Keene wrote:

I'm

getting some errors all of a sudden when using PHP and Perl to connect
to my postgresql database.

I'm running Red Hat Enterprise Linux

Client release 5.6 (Tikanga)

And php-5.1.6-27.el5_5.3

perl-5.8.8-32.el5_5.2

Here's the php error when trying to

connect:

PHP Warning: PHP Startup: Unable to load dynamic library

'/usr/lib64/php/modules/pdo_pgsql.so' - libpq.so.4: cannot open shared
object file: No such file or directory in Unknown on line 0

PHP

Warning: PHP Startup: Unable to load dynamic library
'/usr/lib64/php/modules/pgsql.so' - libpq.so.4: cannot open shared
object file: No such file or directory in Unknown on line 0

And the

perl error:

install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC

(@INC contains:
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .)
at (eval 3) line 3.

Perhaps the DBD::Pg perl module hasn't been fully

installed,

or perhaps the capitalisation of 'Pg' isn't right.

Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.

at

pg_connect.pl line 9

This is strange because the same exact scripts

worked about a month ago. And I do have DBD/pg.pm installed and pgsql.so
and pdo_pgsql.so are also installed.

Is there a simple fix to this?

I have read some ideas about installed libpq.so.4 to fix this, but I
wanted to run this specific problem by some experts before making any
changes.

Thanks for any help,

S

It's seems library libpq.so.4
missing on your server. This can happened if you upgrade your
postgresql.

For perl use:

perl -MCPAN -e shell

and then:

install
DBD::Pg

For perl this is happened when you update your perl version or
postgresql library is missing or is not installed.

--

Regards,
Condor