From: Steve Holdoway <steve.holdoway@firetrust.com>
To: pgsql-admin@postgresql.org
Subject: Re: Database update problem from crontab on ubuntu server
Date: Fri, 18 Apr 2008 10:46:00 +1200
Message-ID: <20080418104600.dbb62b3c.steve.holdoway@firetrust.com> (raw)
In-Reply-To: <4807B143.5080006@mysoft.ge>
References: <4807B143.5080006@mysoft.ge>
On Fri, 18 Apr 2008 00:21:23 +0400
David Jorjoliani <djorj@mysoft.ge> wrote:
> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
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...
Cheers,
Steve
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: steve.holdoway@firetrust.com
Subject: Re: Database update problem from crontab on ubuntu server
In-Reply-To: <20080418104600.dbb62b3c.steve.holdoway@firetrust.com>
* 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