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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of teyking2003 Sent: Monday, December 03, 2012 8:13 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxxx) 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
