Re: cron & backup

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: cron & backup
Дата
Msg-id 20050119110312.GB18648@svana.org
обсуждение исходный текст
Ответ на Re: cron & backup  (Allen <dba@girders.org>)
Список 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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Multiline plpython procedure
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Postgres crashed when adding a sequence column