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