Re: can't run pg_dump in sh script using crontab - Mailing list 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