Re: "missing" library file - Mailing list pgsql-admin

From Tena Sakai
Subject Re: "missing" library file
Date
Msg-id FE44E0D7EAD2ED4BB2165071DB8E328C0378F1DD@egcrc-ex01.egcrc.org
Whole thread Raw
In response to "missing" library file  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin

Hi Everybody,

I found a solution by trial and guessing.
I explicitly coded:

LD_LIBRARY_PATH=/usr/local/pgsql/lib

in the crontab file.  That seems to have
done it.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Tena Sakai
Sent: Mon 4/14/2008 1:05 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] "missing" library file

Hi Everybody,

My postgres version:
PostgreSQL 8.3.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3)

I can reindex a table from psql.  At psql prompt,
I type: reindex table foo;
and it returns
REINDEX
followed by another prompt.

I am trying to get the same thing done via cron.
As I do so what happens is that I get the message:
error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

As non privileged user (as well as user postgres)
I can type:
ls -l ~postgres/lib/libpq*
and get:

-rw-r--r--  1 root root 210218 Feb 13 17:01 /usr/local/pgsql/lib/libpq.a
lrwxrwxrwx  1 root root     12 Mar 24 12:12 /usr/local/pgsql/lib/libpq.so -> libpq.so.5.1
lrwxrwxrwx  1 root root     12 Mar 24 12:12 /usr/local/pgsql/lib/libpq.so.5 -> libpq.so.5.1
-rwxr-xr-x  1 root root 137944 Feb 13 17:01 /usr/local/pgsql/lib/libpq.so.5.1

~postgres is /usr/local/pgsql which is a
symbolic link to /pgsql/pgsql.  Is this a cause
of the problem?  And how would I "fix" this from
crontab?

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: "Kranti K K Parisa™"
Date:
Subject: Re: PostgreSQL 8.1 to 8.3
Next
From: "Ryan Wells"
Date:
Subject: Re: Slow pg_dump