Re: [BUGS] pg_dumpall not working in batch

[Dmitry Tkach]

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 [EMAIL PROTECTED]