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

vacuumdb and pg_dump are not running under cron

From: "Jeff Lu" <jklcom(at)mindspring(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>, <jason(at)tishler(dot)net>
Subject: vacuumdb and pg_dump are not running under cron
Date: 2003-05-12 15:42:42
Message-ID: 001f01c3189d$23738050$1501a8c0@DemoServer (view raw or flat)
Thread:
Lists: pgsql-cygwin
 
Hi,
 
I set up a cron job to run vacuumdb and pg_dump periodically but they
are not being run under cron.  Under command line they worked fine.
 
At first I thought the cron didn't get executed at all so I added
shutdown to in my cron file:
 
9 12 * * * vacuumdb --username=jeff -h localhost jeffdb
9 12 * * * pg_dump --username=jeff jeffdb >
/c/progra~1/apache~1/apache/intrapos/database/intrapos_shdw.dat
9 12 * * * pg_ctl stop -m fast
9 12 * * * shutdown --force --shutdown 10
 
The system got shutdown but the database didn't get stopped, vaccumdb
and pg_dump did not get executed
 
Can someone tell me why that is?
 
Thank you
-Jeff

Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2003-05-12 16:10:59
Subject: Re: vacuumdb and pg_dump are not running under cron
Previous:From: Frank SeesinkDate: 2003-05-09 20:12:01
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