From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: David Jorjoliani <djorj@mysoft.ge>
To: pgsql-admin@postgresql.org
Subject: Re: Database update problem from crontab on ubuntu server
Date: Thu, 17 Apr 2008 17:09:34 -0500
Message-ID: <48078446.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <4807B143.5080006@mysoft.ge>
References: <4807B143.5080006@mysoft.ge>
>>> On Thu, Apr 17, 2008 at 3:21 PM, in message <4807B143.5080006@mysoft.ge>,
David Jorjoliani <djorj@mysoft.ge> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, djorj@mysoft.ge
Subject: Re: Database update problem from crontab on ubuntu server
In-Reply-To: <48078446.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox