>>>>> pg_dump in crontab

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/