Skip site navigation (1) Skip section navigation (2)

Re: Database update problem from crontab on ubuntuserver

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "David Jorjoliani" <djorj(at)mysoft(dot)ge>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database update problem from crontab on ubuntuserver
Date: 2008-04-17 22:09:34
Message-ID: 48078446.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> On Thu, Apr 17, 2008 at  3:21 PM, in message <4807B143(dot)5080006(at)mysoft(dot)ge>,
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?
 
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
 
 



In response to

pgsql-admin by date

Next:From: Steve HoldowayDate: 2008-04-17 22:46:00
Subject: Re: Database update problem from crontab on ubuntu server
Previous:From: David JorjolianiDate: 2008-04-17 20:21:23
Subject: Database update problem from crontab on ubuntu server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group