Re: [BUGS] pg_dumpall not working in batch

2003-06-13 Thread Serge Obeuf
ozilla/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 >

Re: [BUGS] pg_dumpall not working in batch

2003-06-12 Thread 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 wrot

[BUGS] pg_dumpall not working in batch

2003-06-12 Thread Serge Obeuf
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: