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 15:24:17 |
Message-ID: | D15F32DE6D70D411814400508B4492ED55EC66@SVRSPBEXCH01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks a lot for your help !
Regards,
Slava
-----Original Message-----
From: Stefan Huber [mailto:schweinsaug(at)crosswinds(dot)net]
Sent: Saturday, February 10, 2001 6:30 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] ???solution??? --> can't run pg_dump in sh script
usi ng crontab
>"/opt/postgresql/bin/pg_dump: error in loading shared libraries:
>libpq.so.2.1: cannot open shared object file: No such file or directory"
ah, that explains much.
>"You can just put the postgresql lib directory in /etc/ld.so.conf and run
>ldconfig."
Yes, that's it
> But I have a question: is this solution enough for successful pg_dump
>or I have to do something else to exclude failure ?
Maybe, as I stated before, you might needt to allow root to access the
databases or to run your pg_dump-script as
su - oracle -c 'pg_dump <dbname>'
If your database user (oracle) has PG_LIB (I don't remember the variable
exactly, but it's something like that, take a look at the INSTALL file in
the postgresql-source tree) set, then you don't even need ldconfig.
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Huber | 2001-02-10 15:29:30 | RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab |
Previous Message | Kogotkov, Vyacheslav | 2001-02-10 14:58:22 | RE: ???solution??? --> can't run pg_dump in sh script usi ng crontab |