Re: pg_dumpall in crontab doesn't work

Поиск
Список
Период
Сортировка
От Kevin Brannen
Тема Re: pg_dumpall in crontab doesn't work
Дата
Msg-id 3D21B4F3.3040404@nurseamerica.net
обсуждение исходный текст
Ответ на Re: pg_dumpall in crontab doesn't work  ("Guthrie, John" <JGuthrie@air.org>)
Список pgsql-admin
Guthrie, John wrote:
> keep in mind that cronjobs don't get your login environment, so things that
> work in interactive mode often fail in cron unless you make sure to set up
> the environment there too.

That is very important to remember!  First try adding "< /dev/null" to
the command.  If that doesn't work, you can also try adding ".
$HOME/.profile ; " to the command.

HTH,
Kevin

>>>05 22 *  *  1-5 postgres /usr/bin/pg_dumpall -D >
>>>/disks/postgres/db.pg_dumpall




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

Предыдущее
От: BAYET Richard
Дата:
Сообщение: Re: how to re-configure postgresql-rpm version
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Authentication in batch processing