Re: pg_dumpall in crontab doesn't work

Поиск
Список
Период
Сортировка
От Guthrie, John
Тема Re: pg_dumpall in crontab doesn't work
Дата
Msg-id F779B05379CAD2118BD20090273017BF03E79C7D@DC1
обсуждение исходный текст
Ответ на pg_dumpall in crontab doesn't work  (Werner Modenbach <modenbach@alc.de>)
Список pgsql-admin
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.

john guthrie

-----Original Message-----
From: Werner Modenbach [mailto:modenbach@alc.de]
Sent: Tuesday, July 02, 2002 3:51 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_dumpall in crontab doesn't work


Nils Höglund wrote:

>
>> 05 22 *  *  1-5 postgres /usr/bin/pg_dumpall -D >
>> /disks/postgres/db.pg_dumpall
>> connected to template1...
>> /usr/bin/pg_dumpall: 0: Bad file descriptor
>
> Filedescriptor 0 is STDIN. I would guess pg_dumpall want's to read
something
> from stdin, pherhaps ask you a question?
>
But it doesn't ask in interactive (shell) mode.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly




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

Предыдущее
От: Preston de Guise
Дата:
Сообщение: pg_dumpall -> database import -> user problem.
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: db connection fails