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

[Stefan Huber]

>    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