echo "/usr/local/pgsql/lib" >> /etc/ld.so.conf
ldconfig -v
[note >> means APPEND]
That should fix it
--
Mike
"Iwan Tutuka Pambudi" <itpambudi@yahoo.com> wrote in message
news:20010117033047.8997.qmail@web219.mail.yahoo.com...
>
> Hi,
>
> I need to back up my database "test" at 23:30
> everyday.
>
> $ crontab -l
> 30 23 * * * pg_dump test > test.out
>
> I got an error massage
> /bin/sh: pg_dump: command not found
>
> $ which pg_dump
> /usr/local/pgsql/bin/pg_dump
> $ crontab�@-l
> 30 23 * * * /usr/local/pgsql/bin/pg_dump test >
> /home/iwan/test.out
>
> I got another error message
> /usr/local/pgsql/bin/pgdump: error in loading shared
> libraries: libpq.so.2.0: cannot open shared object
> file: No such file or directory
>
> But in my machine libpq.so.2.0 located in
> /usr/local/src/postgresql-6.5.2/src/interface/libpq/libpq.so.2.0
> /usr/local/pgsql/lib/libpq.so.2.0
>
> What's wrong? Please help me ...
>
>
> Thanks in advance
> Iwan
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
