From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com> |
Cc: | "Pgsql-Admin(at)Postgresql(dot) Org (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: can't run pg_dump in sh script using crontab |
Date: | 2001-02-12 00:15:55 |
Message-ID: | Pine.BSF.4.10.10102111600370.86766-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 2>&1| mail -s "test" yourmail(at)your(dot)com
then you can figure out what's wrong.
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com
On Sat, 10 Feb 2001, Kogotkov, Vyacheslav wrote:
> 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
set -x
> PG_BIN=/ora/pgsql/bin
> BACKUP_DEST=/ora/home/FOR_POSTGRES/backup/dump
> $PG_BIN/pg_dump -f $BACKUP_DEST/`date +%d%m%Y`_cspb.dmp dbname
>
> PG_VERSION contains 7.0.
> File HISTORY contains "Release 7.0.3".
> I have a single version of Postgres, so pg_dump
> is the same version.
> I connect to linux as user "oracle". He has an access to
> database "dbname" and can SELECT data using psql. As far as
> I remember, I create this database as user "oracle".
> I usually start postmaster as user "oracle".
> And I edit crontab as "oracle".
> As "oracle", I can run this shell script by hand and get a good
> dump file.
> 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 ?
>
> Thanks,
> Slava
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Orland A. Cajilig | 2001-02-12 05:59:03 | gmake |
Previous Message | Stefan Huber | 2001-02-10 15:29:30 | RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab |