On Fri, 18 Apr 2008 00:21:23 +0400 David Jorjoliani <[EMAIL PROTECTED]> 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
pgp9tEzGlOiJt.pgp
Description: PGP signature
