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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2003-05-12 16:10:59 Re: vacuumdb and pg_dump are not running under cron
Previous Message Frank Seesink 2003-05-09 20:12:01 Re: UPDATE 2: Windows XP, Cygwin 1.3.22-1, PostgreSQL 7.3.2,