From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: perl and php connect problems to pgsql all of a sudden |
Date: | 2011-06-07 15:45:30 |
Message-ID: | 69f623c57492cfba97540b4d350adce9@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tarabas | 2011-06-07 15:50:13 | Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1 |
Previous Message | Vincent Veyron | 2011-06-07 15:37:57 | Re: Recurring events |