Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group