Re: cron & backup - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: cron & backup
Date
Msg-id 20050119110312.GB18648@svana.org
Whole thread Raw
In response to Re: cron & backup  (Allen <dba@girders.org>)
List pgsql-general
On Tue, Jan 18, 2005 at 06:30:32PM -0500, Allen wrote:
> I had a problem in the past with the vaccumdb command on 7.2.3
> mysteriously never returning when run from cron on FreeBSD, but it ran
> fine from cmdline. Had to be an environmental issue. Not having time to
> track it down, I tried an alternative lazy method...
>
> /usr/local/bin/vacuumdb -z -f dbname   <-- sometimes never returned

If it never returned it would still be running right. So it should show
up when you run "ps". You would be able to strace to see what the
problem was. Note, if a script has no output you don't get an email
either.

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Multiline plpython procedure
Next
From: Richard Huxton
Date:
Subject: Re: Postgres crashed when adding a sequence column