Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E63D8650ED1 for ; Wed, 2 Jul 2008 12:57:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29961-04-7 for ; Wed, 2 Jul 2008 12:56:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 524D5650F24 for ; Wed, 2 Jul 2008 12:56:28 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id 06EF6FBCCE5; Wed, 2 Jul 2008 08:56:27 -0700 (PDT) Date: Wed, 2 Jul 2008 08:56:26 -0700 From: David Fetter To: daveg Cc: pgsql-patches@postgresql.org, hari@efrontier.com Subject: Re: pg_dump lock timeout Message-ID: <20080702155626.GC30328@fetter.org> References: <20080511113047.GV5673@sonic.net> <20080511130035.GW5673@sonic.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20080511130035.GW5673@sonic.net> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/16 X-Sequence-Number: 6711 On Sun, May 11, 2008 at 06:00:35AM -0700, David Gould wrote: > On Sun, May 11, 2008 at 04:30:47AM -0700, daveg wrote: > > > > Attached is a patch to add a commandline option to pg_dump to > > limit how long pg_dump will wait for locks during startup. > > Ooops, really attached this time. Can we see about getting this into the July commitfest? Dave has presented a use case complete with logs where having this could have prevented a failed backup and consequent data loss. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate