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

Re: Crontab problem with backup

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kirti <kirti(at)UNSWalumni(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Crontab problem with backup
Date: 2006-04-15 04:28:47
Message-ID: 200604150428.k3F4Sl014355@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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. +

In response to

Responses

pgsql-novice by date

Next:From: noneDate: 2006-04-15 05:12:55
Subject: Install password not recognized
Previous:From: Tom LaneDate: 2006-04-15 04:18:59
Subject: Re: Crontab problem with backup

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