Re: >>>>> pg_dump in crontab

echo "/usr/local/pgsql/lib" >> /etc/ld.so.conf
ldconfig -v

[note >> means APPEND]

That should fix it
--
Mike

"Iwan Tutuka Pambudi" <itpambudi(at)yahoo(dot)com> wrote in message
news:20010117033047(dot)8997(dot)qmail(at)web219(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
>
> 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(at)-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/