Database update problem from crontab on ubuntu server

From: David Jorjoliani <djorj(at)mysoft(dot)ge>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database update problem from crontab on ubuntu server
Date: 2008-04-17 20:21:23
Message-ID: 4807B143.5080006@mysoft.ge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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?

Thanks,
David

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2008-04-17 22:09:34 Re: Database update problem from crontab on ubuntu server
Previous Message Jesper Krogh 2008-04-17 19:48:49 autovacuum?