>>>>> pg_dump in crontab - Mailing list pgsql-general

From Iwan Tutuka Pambudi
Subject >>>>> pg_dump in crontab
Date
Msg-id 20010117033047.8997.qmail@web219.mail.yahoo.com
Whole thread Raw
Responses Re: >>>>> pg_dump in crontab
List 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�@-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/

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: pg_log
Next
From: Alfred Perlstein
Date:
Subject: Re: MySQL file system