Ahh. When you said "root" I thought you meant "/". Yes, if in /root, then /root/autopgdump.sh You must specify absolute path in cron. ...spike (Sent via handheld, please pardon spelling errors) On Dec 4, 2012, at 7:48 PM, teyking2003 <tchongking@xxxxxxxxxxx> wrote: > so if i putting the .SH files under root directory > the cronjob will look similar like > 30 09 * * * /root/autopgdump.sh > > please advice? > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Cronjob-to-autobackup-database-tp5734873p5735088.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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin