Re: pg_dumpall in crontab doesn't work - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dumpall in crontab doesn't work
Date
Msg-id 12444.1025616740@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall in crontab doesn't work  (Werner Modenbach <modenbach@alc.de>)
List 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 by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: db connection fails
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall -> database import -> user problem.