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

2001-02-12 Thread Kogotkov, Vyacheslav
Jie, Thanks for your reply. I will try this. Regards, Slava -Original Message- From: Jie Liang [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 3:16 AM To: Kogotkov, Vyacheslav Cc: Pgsql-Admin@Postgresql. Org (E-mail) Subject: Re: [ADMIN] can't run pg_dump in sh

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

2001-02-11 Thread Jie Liang
Hmm, I run pg_dump with crontab seems OK. I guess it might be some permission problem. you may try your script with some debuging method like: add set -x in your script and in cron pipe it to your email: 0?? * * * youruser fullpath/yourscript 21| mail -s "test" [EMAIL

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

2001-02-10 Thread Kogotkov, Vyacheslav
Dear colleagues, Besides I am new to Postgres, I am new to linux too. I have a sh-script which run pg_dump by hand successfully. But I have no results when I run this script using crontab. I haven't got any error log. Please, help me. Here is my sh-script: #!/bin/sh

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

2001-02-10 Thread 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,