Re: pg_dumpall not working in batch - Mailing list pgsql-bugs

From Serge Obeuf
Subject Re: pg_dumpall not working in batch
Date
Msg-id 200306130820.h5D8Kgj16948@jade.jouy.inra.fr
Whole thread Raw
In response to pg_dumpall not working in batch  (Serge Obeuf <obeuf@jade.jouy.inra.fr>)
List pgsql-bugs
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.org@localhost.postgresql.org
>Date: Thu, 12 Jun 2003 12:49:05 -0400
>From: Dmitry Tkach <dmitry@openratings.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@jade.jouy.inra.fr>
>Cc: pgsql-bugs@postgresql.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@postgresql.org

Serge Obeuf
DISI/SI

pgsql-bugs by date:

Previous
From: Tomas Szepe
Date:
Subject: Re: db growing out of proportion
Next
From: "Brian O'Donoghue"
Date:
Subject: 7.3.3 ADD COLUMN wierdness