From: | Iwan Tutuka Pambudi <itpambudi(at)yahoo(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | >>>>> pg_dump in crontab |
Date: | 2001-01-17 03:30:47 |
Message-ID: | 20010117033047.8997.qmail@web219.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2001-01-17 03:43:42 | Re: MySQL file system |
Previous Message | Joseph Shraibman | 2001-01-17 03:24:44 | Re: pg_log |