Re: Crontab problem with backup

Tom Lane wrote:
> Kirti <kirti(at)UNSWalumni(dot)com> writes:
> > 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
>
> Are you sure you've got the crontab file format correct? On my machine,
> at least, there's no userid column.

That is a BSD-ism.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +