Re: vacuumdb and pg_dump are not running under cron

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