Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1D6392E2F64 for ; Fri, 8 Feb 2008 16:55:22 -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 15788-01-7 for ; Fri, 8 Feb 2008 16:55:12 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 263952E3EF3 for ; Fri, 8 Feb 2008 16:55:08 -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 1JNaFN-0000Be-8q for pgsql-admin@postgresql.org; Fri, 08 Feb 2008 15:54:57 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 80D7650023; Fri, 8 Feb 2008 15:54:52 -0500 (EST) Date: Fri, 8 Feb 2008 15:54:52 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: pg_dump on windows Message-ID: <20080208205452.GB18088@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <20080208.133033.12498.1@webmail07.vgs.untd.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20080208.133033.12498.1@webmail07.vgs.untd.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/108 X-Sequence-Number: 28182 On Fri, Feb 08, 2008 at 06:30:33PM +0000, dghundt@netzero.net wrote: > > LOG unexpected EOF on client connection > LOG unexpected EOF on client connection > LOG unexpected EOF on client connection This means the back end thinks the client disappeared. What is the probability you have a firewall in between your client and the server? Some of them "helpfully" drop the connection after some period of "inactivity". Since you're just sitting there waiting for the command to complete, you look like you have no activity. > In locks tab > I see about 30 locks listed all for the same large table > They are all for the same start time of 11:35am > Mode: accessShareLock > Granted: yes. they all say yes for granted. If they're all granted, you're not waiting for one. A