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@tishler.net]
Sent: Monday, May 12, 2003 12:43 PM
To: Jeff Lu
Cc: pgsql-cygwin@postgresql.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