Hello All,
I recently installed PostgreSQL version 7.1.2 on my system running Linux
6.2 and perl 5.6.1. Oddly, when I installed the rpm file
postgresql-perl-7.1.2-4PGDG.i386.rpm, it installed an older version of
perl into /usr/lib/perl5/5.00503 (compiled apparently for Linux running
on i386, while my version of perl is compiled for Linux running on
i686). Now, when I try to run a perl script that attempts to access a
postgresql database through DBI::Pg, I get the following error message:
[tc0001] Can't load
'/usr/apps/lib/perl5/site_perl/5.6.1/i686-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.00503/i386-linux/DynaLoader.pm line 169
([tc0001] refers to a Parallel Virtual Machine task #).
The libpq.so.2 file is there, in /usr/lib. When I run ldd on Pg.so, I
get the following output, which apparently tells me that everything is
"OK":
libpq.so.2 => /usr/lib/libpq.so.2 (0x2aab9000)
libc.so.6 => /lib/libc.so.6 (0x2aacd000)
libssl.so.0 => /usr/lib/libssl.so.0 (0x2abc2000)
libcrypto.so.0 => /usr/lib/libcrypto.so.0 (0x2abef000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x2acae000)
libresolv.so.2 => /lib/libresolv.so.2 (0x2acdb000)
libnsl.so.1 => /lib/libnsl.so.1 (0x2acea000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
I ran ldconfig without any success. I did check the [extensive]
discussion of the missing libpq.so.2 file at
http://postgresql.bnv-bamberg.de/mhonarc/pgsql-general/2000-11/msg00188.html,
and my file libpq.so.2 (according to the solution suggested by Lamar on
the forum) is already symlinked to libpq.so.2.1.
Further suggestions, anyone?
Thanks!
Alex