On Wed, Mar 28, 2001 at 10:59:05AM -0500, Peter Seabrook wrote:
> When executing a CGI script with the following connect statement:
> $dbh =
> DBI->connect('DBI:Pg:dbname=shop;host=192.168.100.8;port=5432','postgres',''
> ,{ RaiseError => 1, AutoCommit => 1});
>
> I receive the following error:
>
> perl: error while loading shared libraries:
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Pg/Pg.so: undefined
> symbol: PQconnectdb
The dynamic linker can't find the PostgreSQL shared libraries. First
check that you've got them installed: there should be a symlink called
"libpq.so" in /usr/lib/, pointing, after following a trail of symlinks,
to libpq.so.2.1 . If that's not there you've probably not installed all
of the rpms you need - but I think that library is in the -server rpm,
so if you've got PostgreSQL installed at all then you've got it. If it
*is* there, then you need to run "ldconfig" (as root) so that your
dynamic linker can see it.
Richard