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

Re: vacuumdb and pg_dump are not running under cron

From: Jason Tishler <jason(at)tishler(dot)net>
To: Jeff Lu <jklcom(at)mindspring(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: vacuumdb and pg_dump are not running under cron
Date: 2003-05-12 16:43:20
Message-ID: 20030512164320.GF1708@tishler.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Jeff,

On Mon, May 12, 2003 at 12:29:50PM -0400, Jeff Lu wrote:
> Actually I do have these in a shell script file name "backupsys"
> vacuumdb --username=jeff -h localhost jeffdb
> pg_dump --username=jeff jeffdb >> /c/progra~1/apache~1/apache/ intrapos/database/intrapos_shdw.dat
> pg_ctl stop -m fast

Good.

> My cron really looks like this:
> 9 12 * * * /c/progra~1/apache~1/apache/cgi-bin/backupsys

Change the above to the following:

    9 12 * * * /c/progra~1/apache~1/apache/cgi-bin/backupsys >>/tmp/backupsys.log 2>&1

Does examining the contents of /tmp/backupsys.log help you debug the
problem?

Jason

-- 
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6


In response to

Responses

pgsql-cygwin by date

Next:From: Frank SeesinkDate: 2003-05-12 17:22:03
Subject: Re: UPDATE 2: Windows XP, Cygwin 1.3.22-1, PostgreSQL 7.3.2,
Previous:From: Jason TishlerDate: 2003-05-12 16:39:29
Subject: Re: UPDATE 2: Windows XP, Cygwin 1.3.22-1, PostgreSQL 7.3.2,

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