Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-04-17 22:09:34
Subject: Re: Database update problem from crontab on ubuntuserver
Previous:From: Jesper KroghDate: 2008-04-17 19:48:49
Subject: autovacuum?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group