Re: [ADMIN] pg_dumpall in crontab doesn't work

Werner Modenbach wrote: > Guthrie, John wrote: > > > 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. > > > Thanks John, > > actually I didn't know that :-

Re: [ADMIN] pg_dumpall in crontab doesn't work

Guthrie, John wrote: > 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. That is very important to remember! First try adding "< /dev/null" to the command. If tha

Re: [ADMIN] pg_dumpall in crontab doesn't work

Guthrie, John wrote: > 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. > Thanks John, actually I didn't know that :-( In the meantime I added the "http://archiv

Re: [ADMIN] pg_dumpall in crontab doesn't work

Werner Modenbach <[EMAIL PROTECTED]> 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

Re: [ADMIN] pg_dumpall in crontab doesn't work

ly 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: B

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 y

Re: [ADMIN] pg_dumpall in crontab doesn't work

> 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? -- /Nils Höglund,

[ADMIN] pg_dumpall in crontab doesn't work

I'm doing some backup action for my database using crontab. Unfortunately the following entry doesn't work and I can't figure out the problem: - /etc/crontab --- 05 22 * * 1-5 postgres /usr/bin/pg_dumpall -D > /disks/postgres/db.pg_dumpall --