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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of teyking2003
Sent: Monday, December 03, 2012 8:13 PM
To: pgsql-admin@postgresql.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@postgresql.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