Re: pg_dumpall in crontab doesn't work

From: Kevin Brannen <kevinb(at)nurseamerica(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall in crontab doesn't work
Date: 2002-07-02 14:13:07
Message-ID: 3D21B4F3.3040404@nurseamerica.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-07-02 15:25:31 Re: Authentication in batch processing
Previous Message Werner Modenbach 2002-07-02 13:45:36 Re: pg_dumpall in crontab doesn't work