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/