Re: pg_dumpall in crontab doesn't work - Mailing list pgsql-admin

From Werner Modenbach
Subject Re: pg_dumpall in crontab doesn't work
Date
Msg-id afsaps$1k08$1@news.hub.org
Whole thread Raw
In response to Re: pg_dumpall in crontab doesn't work  ("Guthrie, John" <JGuthrie@air.org>)
Responses Re: pg_dumpall in crontab doesn't work  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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 "</dev/null" as proposed by Tom and it works
fine now :-))
Seems like pg_dump needs it. Maybe this can be improved in future?

- Werner -

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dumpall -> database import -> user problem.
Next
From: Kevin Brannen
Date:
Subject: Re: pg_dumpall in crontab doesn't work