Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 93F932E0042 for ; Thu, 17 Apr 2008 18:25:35 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77165-03 for ; Thu, 17 Apr 2008 18:25:32 -0300 (ADT) X-Greylist: delayed 00:57:02.176989 by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.188]) by developer.postgresql.org (Postfix) with ESMTP id 550712E0037 for ; Thu, 17 Apr 2008 18:25:31 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id w9so261848mue.3 for ; Thu, 17 Apr 2008 14:25:30 -0700 (PDT) Received: by 10.82.145.19 with SMTP id s19mr2983787bud.27.1208463687383; Thu, 17 Apr 2008 13:21:27 -0700 (PDT) Received: from ?10.0.0.12? ( [85.117.32.62]) by mx.google.com with ESMTPS id c22sm15654979ika.3.2008.04.17.13.21.24 (version=SSLv3 cipher=RC4-MD5); Thu, 17 Apr 2008 13:21:26 -0700 (PDT) Message-ID: <4807B143.5080006@mysoft.ge> Date: Fri, 18 Apr 2008 00:21:23 +0400 From: David Jorjoliani User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Database update problem from crontab on ubuntu server Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/180 X-Sequence-Number: 28944 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