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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]