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: [EMAIL PROTECTED] >Date: Thu, 12 Jun 2003 12:49:05 -0400 >From: Dmitry Tkach <[EMAIL PROTECTED]> >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 <[EMAIL PROTECTED]> >Cc: [EMAIL PROTECTED] >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 [EMAIL PROTECTED] Serge Obeuf DISI/SI ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
