>>> On Thu, Apr 17, 2008 at 3:21 PM, in message <[EMAIL PROTECTED]>, David Jorjoliani <[EMAIL PROTECTED]> wrote: > I have daily cron jobs for database update, which where working fine on > Fedore Core 6. No I move it on Ubuntu Server 7.10 and postgres gives error: > > "unexpected EOF on client connection" > > while update running from cron. If I run this update manually from root > user - it works fine. Here is update command: > > su -l postgres -c "gunzip -c /backup/rms.gz | psql rms" > > Can somebody give any suggestion? Not that this should matter, but do you have the same result with?: su -l postgres -c "gunzip < /backup/rms.gz | psql rms" I would recommend specifying the full path for the executables. You don't always have the normal $PATH for the user under cron. -Kevin
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
