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

From Kevin Brannen
Subject Re: pg_dumpall in crontab doesn't work
Date
Msg-id 3D21B4F3.3040404@nurseamerica.net
Whole thread Raw
In response to Re: pg_dumpall in crontab doesn't work  ("Guthrie, John" <JGuthrie@air.org>)
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.

That is very important to remember!  First try adding "< /dev/null" to
the command.  If that doesn't work, you can also try adding ".
$HOME/.profile ; " to the command.

HTH,
Kevin

>>>05 22 *  *  1-5 postgres /usr/bin/pg_dumpall -D >
>>>/disks/postgres/db.pg_dumpall




pgsql-admin by date:

Previous
From: BAYET Richard
Date:
Subject: Re: how to re-configure postgresql-rpm version
Next
From: Bruce Momjian
Date:
Subject: Re: Authentication in batch processing