Re: pg_dumpall not working in batch

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
>
>