Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 455402E004C for ; Thu, 28 Feb 2008 11:41:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33013-04 for ; Thu, 28 Feb 2008 11:40:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id F1CA92E00DD for ; Thu, 28 Feb 2008 11:40:57 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JUksS-0004NJ-Qb for pgsql-admin@postgresql.org; Thu, 28 Feb 2008 10:40:56 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 956375002D; Thu, 28 Feb 2008 10:40:51 -0500 (EST) Date: Thu, 28 Feb 2008 10:40:51 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Meaning of logs of postgresql Message-ID: <20080228154051.GA15157@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <3D5445983859B84B92669C0D883EA6FB0C781050@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C781050@ZENMAILHQ1.ind.zensar.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/399 X-Sequence-Number: 28473 On Thu, Feb 28, 2008 at 06:15:29PM +0530, Suresh Gupta VG wrote: > WARNING: there is no transaction in progress This means you issued COMMIT when there was no BEGIN that started the transaction. I bet you're in autocommit mode and don't know it. > LOG: unexpected EOF on client connection This means the client disappeared. Are you disconnecting without closing your connections? A