From: | "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com> |
---|---|
To: | "'Richard Huxton'" <dev(at)archonet(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: RE: can't run pg_dump in sh script using crontab |
Date: | 2001-02-10 15:41:37 |
Message-ID: | D15F32DE6D70D411814400508B4492ED55EC67@SVRSPBEXCH01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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: Richard Huxton [mailto:dev(at)archonet(dot)com]
Sent: Saturday, February 10, 2001 6:38 PM
To: Kogotkov, Vyacheslav
Cc: pgsql-general
Subject: Re: [GENERAL] RE: can't run pg_dump in sh script using crontab
From: "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com>
> PG_VERSION contains 7.0
> I have a single version of Postgres, so pg_dump
> is the same version. File HISTORY contains "Release 7.0.3".
> 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 ?
Make sure you set any environment variables you need. You are probably
missing a path or one of the PGxxx environment vars.
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | <No Name> | 2001-02-10 16:16:45 | Importing a Database |
Previous Message | Richard Huxton | 2001-02-10 15:37:40 | Re: RE: can't run pg_dump in sh script using crontab |