Message-Id: <48078446.EE98.0025.0@wicourts.gov>
Date: Thu, 17 Apr 2008 17:09:34 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "David Jorjoliani" <djorj@mysoft.ge>,<pgsql-admin@postgresql.org>
Subject: Re: Database update problem from crontab on ubuntu
	server
References: <4807B143.5080006@mysoft.ge>
In-Reply-To: <4807B143.5080006@mysoft.ge>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

>>> On Thu, Apr 17, 2008 at  3:21 PM, in message <4807B143.5080006@mysoft.g=
e>,
David Jorjoliani <djorj@mysoft.ge> wrote:=20
=20
> 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:
>=20
> "unexpected EOF on client connection"
>=20
> while update running from cron. If I run this update manually from root
> user - it works fine. Here is update command:
>=20
> su -l postgres -c "gunzip -c /backup/rms.gz | psql rms"
>=20
> Can somebody give any suggestion?
=20
Not that this should matter, but do you have the same result with?:
=20
su -l postgres -c "gunzip < /backup/rms.gz | psql rms"
=20
I would recommend specifying the full path for the executables.  You
don't always have the normal $PATH for the user under cron.
=20
-Kevin
=20
=20