Re: Big problem about libpq.so.2.1, ldconfig and ldd

> On a machine with 7.0.2, we have this :
>
> ldconfig -p |grep libpq.so
> libpq.so.2.1 (libc6) => /usr/local/pgsql/lib/libpq.so.2.1
> libpq.so.2 (libc6) => /usr/local/pgsql/lib/libpq.so.2
> libpq.so (libc6) => /usr/local/pgsql/lib/libpq.so
>
> On an other machine with 7.1.3, we have this :
>
> ldconfig -p |grep libpq.so
> libpq.so.2 (libc6) => /usr/local/pgsql/lib/libpq.so.2
> libpq.so (libc6) => /usr/local/pgsql/lib/libpq.so

It should be like this:

lrwxrwxrwx 1 root other 12 des 10 14:58 libpq.so ->
libpq.so.2.1
lrwxrwxrwx 1 root other 12 des 10 14:58 libpq.so.2 ->
libpq.so.2.1
-rwxr-xr-x 1 root other 78114 des 10 14:58 libpq.so.2.1

Hmm, why don't you go to /usr/local/pgsql/lib on your second machine and
do "ls -la libpq*". Then figure out what is the real file and what is
the symbolic link. Rename the real file to libpq.so.2.1 and then make
two symbolic links libpq.so and libpq.so.2 to point to libpq.so.2.1.
This is something wrong with your installation on the second machine,
but this should resolve the problem. This basically has nothing to do
with Postgres (although it is about Postgres library), but this is plain
Unix problem with loading libraries.

Regards,
Boban Acimovic
www.mbl.is