From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | Serge Obeuf <obeuf(at)jade(dot)jouy(dot)inra(dot)fr> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_dumpall not working in batch |
Date: | 2003-06-12 16:49:05 |
Message-ID: | 3EE8AF01.6070003@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
You must have some environment setting (like LD_LIBRARY_PATH?) in your
.login or .bashrc (or whatever shell you are using), that tells psql
where to find that library. When you run it via cron, that environment
isn't being set and causes it to fail.
I hope, it helps...
Dima
Serge Obeuf wrote:
> Hi all,
>
> I've recently posted here some question about pg_dumpall (7.2) on
> Solaris8.
> Investigating, I reduce my problem cases.
>
> When I plan in crontab 'pg_dumpall > dball.sql', I receive this error:
> connected to template1...
> ld.so.1: /usr/local/public/pgsql/bin/psql: fatal: libpq.so.2: open
> failed: No
> such file or directory
> Killed
>
> But, when this same command 'pg_dumpall > dball.sql' is typed
> interactively,
> this is well working.
>
> Thanks for idea.
>
>--
>Serge Obeuf
>DISI/SI
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-12 17:30:58 | Re: Bug in SQL function with returntype void |
Previous Message | Serge Obeuf | 2003-06-12 12:50:51 | Pg_dumpall in batch |