Thread: pg_dumpall not working in batch

pg_dumpall not working in batch

From
Serge Obeuf
Date:
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

Re: pg_dumpall not working in batch

From
Dmitry Tkach
Date:
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
>
>

Re: pg_dumpall not working in batch

From
Serge Obeuf
Date:
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