This is a multi-part message in MIME format.
------_=_NextPart_001_01C89E6A.E94FFCA2
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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@[EMAIL PROTECTED]
text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7651.59">
<TITLE>"missing" library file</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=3D2>Hi Everybody,<BR>
<BR>
My postgres version:<BR>
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)<BR>
<BR>
I can reindex a table from psql. At psql prompt,<BR>
I type: reindex table foo;<BR>
and it returns<BR>
REINDEX<BR>
followed by another prompt.<BR>
<BR>
I am trying to get the same thing done via cron.<BR>
As I do so what happens is that I get the message:<BR>
error while loading shared libraries: libpq.so.5: cannot open shared =
object file: No such file or directory<BR>
<BR>
As non privileged user (as well as user postgres)<BR>
I can type:<BR>
ls -l ~postgres/lib/libpq*<BR>
and get:<BR>
<BR>
-rw-r--r-- 1 root root 210218 Feb 13 17:01 =
/usr/local/pgsql/lib/libpq.a<BR>
lrwxrwxrwx 1 root root 12 Mar 24 12:12 =
/usr/local/pgsql/lib/libpq.so -> libpq.so.5.1<BR>
lrwxrwxrwx 1 root root 12 Mar 24 12:12 =
/usr/local/pgsql/lib/libpq.so.5 -> libpq.so.5.1<BR>
-rwxr-xr-x 1 root root 137944 Feb 13 17:01 =
/usr/local/pgsql/lib/libpq.so.5.1<BR>
<BR>
~postgres is /usr/local/pgsql which is a<BR>
symbolic link to /pgsql/pgsql. Is this a cause<BR>
of the problem? And how would I "fix" this from<BR>
crontab?<BR>
<BR>
Regards,<BR>
<BR>
Tena Sakai<BR>
tsakai@[EMAIL PROTECTED]
>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C89E6A.E94FFCA2--
|
