# To back up PostgreSQL database

date=`date '+%Y%m%d-%H%M%S'`

pg_dump -cO -U user database > /root/db_back/pgsql-$date.sql

Ceri Davies wrote:

On Fri, Jan 17, 2003 at 05:35:47PM -0500, Gerard Samuel wrote:

Im trying to setup a cron job to back up my db.
If I manually execute the script it works fine, but the cron job isn't executing the job.

## Backup PostgreSQL database
*/1 * * * * /root/bin/pgsql-back 2> /dev/null > /dev/null

Anyone notice anything with this crontab entry???

Show us the script.
It's probably your path.


Gerard Samuel

To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message

Reply via email to