Re: vacuumdb and pg_dump are not running under cron

Jason,

I'm getting permission denied

VACUUM
/c/progra~1/apache~1/apache/cgi-bin/monday: cannot create
/c/progra~1/apache~1/apache/intrapos/database/intrapos_mon.dat:
permission denied

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Monday, May 12, 2003 12:43 PM
To: Jeff Lu
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: 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