Re: RE: can't run pg_dump in sh script using crontab - Mailing list pgsql-general

From Richard Huxton
Subject Re: RE: can't run pg_dump in sh script using crontab
Date
Msg-id 005101c09377$6935d1e0$1001a8c0@archonet.com
Whole thread Raw
In response to RE: can't run pg_dump in sh script using crontab  ("Kogotkov, Vyacheslav" <Vyacheslav.Kogotkov@artificial-life.com>)
List pgsql-general
From: "Kogotkov, Vyacheslav" <Vyacheslav.Kogotkov@artificial-life.com>

>    PG_VERSION contains 7.0
>    I have a single version of Postgres, so pg_dump
> is the same version. File HISTORY contains "Release 7.0.3".
> I connect to linux as user "oracle". He has an access to
> database "dbname" and can SELECT data using psql. As far as
> I remember, I create this database as user "oracle".
> I usually start postmaster as user "oracle".
> And I edit crontab as "oracle".
> As "oracle", I can run this shell script by hand and get a good
> dump file.
>    But I get nothing if I run it using cron.
>    I think, may be oracle pg_dump can't find database
> "dbname" when it runs by crontab ?

Make sure you set any environment variables you need. You are probably
missing a path or one of the PGxxx environment vars.

- Richard Huxton


pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Trigger using function written in PL/PGSQL returns "Unrecognized language specified"
Next
From: "Kogotkov, Vyacheslav"
Date:
Subject: RE: RE: can't run pg_dump in sh script using crontab