Re: pg_dumpall in crontab doesn't work

From: "Guthrie, John" <JGuthrie(at)air(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall in crontab doesn't work
Date: 2002-07-02 12:09:00
Message-ID: F779B05379CAD2118BD20090273017BF03E79C7D@DC1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-07-02 12:31:12 Re: db connection fails
Previous Message Simeone, Mario 2002-07-02 11:56:39 unsubscribe