Re: pg_dumpall in crontab doesn't work

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(at)alc(dot)de]
Sent: Tuesday, July 02, 2002 3:51 AM
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly