Re: pg_dumpall not working in batch

Thanks Dima for this help.

But, on test machine, my batch is well doing. Test and Productive machine
are exactly similar except ressources notions.

>X-Original-To: pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
>Date: Thu, 12 Jun 2003 12:49:05 -0400
>From: Dmitry Tkach <dmitry(at)openratings(dot)com>
>User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
>X-Accept-Language: en-us, en
>MIME-Version: 1.0
>To: Serge Obeuf <obeuf(at)jade(dot)jouy(dot)inra(dot)fr>
>Cc: pgsql-bugs(at)postgresql(dot)org
>Subject: Re: [BUGS] pg_dumpall not working in batch
>Content-Transfer-Encoding: 7bit
>
>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
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Serge Obeuf
DISI/SI