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