Re: pg_dumpall in crontab doesn't work

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

I was going to suggest that it's trying to read a password.  Are you
sure you don't have password authentication enabled?

You might try adding < /dev/null to the cron entry.  I would have thought
that would be the default, but perhaps it isn't on your machine.

            regards, tom lane



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

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