Re: Cronjob to autobackup database

Here is a crontab example. I always specify the absolute path.

0 0 * * * /postgresql/home/scripts/backup/backup_wal_enabled_instance.sh inst1 5432

Peter Krawetzky

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of teyking2003
Sent: Monday, December 03, 2012 8:13 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Cronjob to autobackup database

i have a cronjob setting up as below
1)Command crontab -e
2)Keyin 30 09 * * * /autopgdump.sh
3) Save to new crontab file.
but nothing happen, the backup process won't start.

i manage to perform manual backup by running the following command sudo ./autopgdump.sh( SH file store under root directory

looking for the correct ways to setting up the cronjob.

thanks

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Cronjob-to-autobackup-database-tp5734873.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna