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:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:51 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply via email to