From: Oliver Kohll <oliver@gtwebmarque.com>
To: pgsql-interfaces@postgresql.org
Subject: upgrade clobbers PERL DBD interface
Date: Mon, 17 Feb 2003 01:17:07 +0000
Message-ID: <200302170117.07935.oliver@gtwebmarque.com> (raw)
Hi,
I've come across this problem a couple of times, first when upgrading to
7.2.something, then from that to 7.3.2 (I forgot it happened the first time,
duh).
After upgrading the installation as per the INSTALL doc, PERL scripts which
use DBI;
my $dbh = DBI->connect('DBI:Pg:dbname=...
fail with the error
install_driver(Pg) failed: Can't load
'/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Pg/Pg.so' for module
DBD::Pg: libpq.so.2: cannot open shared object file: No such file or
directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/apache/cgi-bin/myscript.cgi line 78
Happily, reinstalling the PERL module with
cpan> install DBD::Pg
rectified the situation.
My configuration was
./configure --with-perl
Although the INSTALL file says this is to build the PL/Perl internal language,
not the DBI interface, I wonder if this could have something to do with it.
Actually, looking through my records I see I've come across this error message
before as well, mabye or mabye not due to a postgres upgrade and the solution
then was to run ldconfig after making sure the path to a .so file was in the
ldconfig configuration file.
I'm not sure how many people this would affect, but I thought I'd better
notify someone as it has occured on two different servers of ours, a FreeBSD
virtual private server and a redhat 7.2.
--
Regards,
Oliver
GT webMarque
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: oliver@gtwebmarque.com
Subject: Re: upgrade clobbers PERL DBD interface
In-Reply-To: <200302170117.07935.oliver@gtwebmarque.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox