From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: "missing" library file |
Date: | 2008-04-14 20:58:47 |
Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C0378F1DD@egcrc-ex01.egcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gallo(dot)ucsf(dot)edu
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Tena Sakai
Sent: Mon 4/14/2008 1:05 PM
To: pgsql-admin(at)postgresql(dot)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(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Wells | 2008-04-14 22:35:32 | Re: Slow pg_dump |
Previous Message | Kranti K K Parisa™ | 2008-04-14 20:29:33 | Re: PostgreSQL 8.1 to 8.3 |