On Fri, 18 Apr 2008 00:21:23 +0400
David Jorjoliani <djorj(at)mysoft(dot)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?
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
In crontab you have almost no $PATH set up by default. My expectation is that it can't find gunzip. Try either setting the PATH in the script, or using the full pathname of gunzip instead...
In response to
pgsql-admin by date
|Next:||From: Michael Monnerie||Date: 2008-04-17 23:20:24|
|Subject: Re: duplicate primary index in bayes db from SpamAssassin|
|Previous:||From: Kevin Grittner||Date: 2008-04-17 22:09:34|
|Subject: Re: Database update problem from crontab on ubuntuserver|