Re: can't run pg_dump in sh script using crontab

From: Stefan Huber <schweinsaug(at)crosswinds(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: can't run pg_dump in sh script using crontab
Date: 2001-02-10 14:31:24
Message-ID: 5.0.2.1.0.20010210152757.009fbcf0@pop.crosswinds.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> 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 ?

Ist your crontab a systemwide one? (ie: /etc/crontab ?) this one's normally
run as root, but you may specify a special user. does your script run as
root, too? So you might ewant to un your script as
* * * * * su - oracle -c '/path/to/script/yourscript'

Stefan

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kogotkov, Vyacheslav 2001-02-10 14:58:22 RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab
Previous Message Kogotkov, Vyacheslav 2001-02-10 11:35:12 can't run pg_dump in sh script using crontab