From: | "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com> |
---|---|
To: | "'Jie Liang'" <jliang(at)ipinc(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 08:55:07 |
Message-ID: | D15F32DE6D70D411814400508B4492ED55EC6B@SVRSPBEXCH01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Jie,
Thanks for your reply.
I will try this.
Regards,
Slava
-----Original Message-----
From: Jie Liang [mailto:jliang(at)ipinc(dot)com]
Sent: Monday, February 12, 2001 3:16 AM
To: Kogotkov, Vyacheslav
Cc: Pgsql-Admin(at)Postgresql(dot) Org (E-mail)
Subject: Re: [ADMIN] can't run pg_dump in sh script using crontab
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 | Jean-Arthur Silve | 2001-02-12 09:11:59 | Porstgress forgot all ! Help ! |
Previous Message | Orland A. Cajilig | 2001-02-12 05:59:03 | gmake |