Crontab problem with backup

From: Kirti <kirti(at)UNSWalumni(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Crontab problem with backup
Date: 2006-04-15 01:58:03
Message-ID: 4440532B.6090602@UNSWalumni.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I was trying to backup a database called "old_db".The following lines
inserted into either root crontab file or postgres crontab file failed
either to produce any output or created an empty file caled
"old_db_hr9.tgz" in the /backups/hour/ directory..

0 9 * * 1-5 postgres pg_dump --format=t old_db >
/backups/hour/old_db_hr9.tgz

0 18 * * 5 postgres pg_dump --format=t old_db >
/backups/week/old_db_friday.tgz

What logs do I need to check to find the problem? What might be a way to
test the script?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2006-04-15 03:24:28 Re: Crontab problem with backup
Previous Message Martin Foster 2006-04-15 00:02:47 Re: On the subject of inheritance