From: | "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com> |
---|---|
To: | "'Stefan Huber'" <schweinsaug(at)crosswinds(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab |
Date: | 2001-02-10 14:58:22 |
Message-ID: | D15F32DE6D70D411814400508B4492ED55EC65@SVRSPBEXCH01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you for your help.
I managed to get an output by mail:
"/opt/postgresql/bin/pg_dump: error in loading shared libraries:
libpq.so.2.1: cannot open shared object file: No such file or directory"
I've just found a solution from old postgresql archive:
"You can just put the postgresql lib directory in /etc/ld.so.conf and run
ldconfig."
It seems to be working. I've just got a dump file.
But I have a question: is this solution enough for successful pg_dump
or I have to do something else to exclude failure ?
Thanks
Slava
-----Original Message-----
From: Stefan Huber [mailto:schweinsaug(at)crosswinds(dot)net]
Sent: Saturday, February 10, 2001 5:31 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] can't run pg_dump in sh script using crontab
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Kogotkov, Vyacheslav | 2001-02-10 15:24:17 | RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab |
Previous Message | Stefan Huber | 2001-02-10 14:31:24 | Re: can't run pg_dump in sh script using crontab |