Re: PostgreSQL perl / libpq.so.2 problem - again :(

This might sound like a flame, but it isn't meant to be. Uninstall the rpm
packages that are giving you trouble and reinstall them from source. For me,
rpm's are just grief, especially for apps that I'm going to do a lot of
configuration anyway. That's why I use slackware where I can, but even on our
Mandrake server (not my choice), I convinced the admin to let me compile
postgresql and apache from source, both to get the most recent updates
immediately and so they could be optimized for that machine.

OTOH, if you can get the rpm's to work, by all means more power to you.

Alexander Turchin <aturchin%chip(dot)org(at)interlock(dot)lexmark(dot)com> on 07/05/2001
06:18:35 PM

To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] PostgreSQL perl / libpq.so.2 problem - again :(

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly