Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CD5626503BC; Fri, 25 Jul 2008 18:19:03 -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 44913-03-3; Fri, 25 Jul 2008 18:18:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mk-outboundfilter-5.mail.uk.tiscali.com (mk-outboundfilter-5.mail.uk.tiscali.com [212.74.114.1]) by postgresql.org (Postfix) with ESMTP id D987E6503B4; Fri, 25 Jul 2008 18:18:43 -0300 (ADT) X-Trace: 61960552/mk-outboundfilter-5.mail.uk.tiscali.com/F2S/$F2S-NILDRAM-ACCEPTED/f2s-temporary-group/85.211.229.155 X-SBRS: None X-RemoteIP: 85.211.229.155 X-IP-MAIL-FROM: simon@2ndquadrant.com X-IP-BHB: Once X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AkcBAGDgiUhV0+Wb/2dsb2JhbAAIsCQ X-IronPort-AV: E=Sophos;i="4.31,254,1215385200"; d="scan'208";a="61960552" X-IP-Direction: IN Received: from 85-211-229-155.dyn.gotadsl.co.uk (HELO [192.168.0.3]) ([85.211.229.155]) by smtp.f2s.tiscali.co.uk with ESMTP; 25 Jul 2008 22:18:28 +0100 Subject: Re: [PATCHES] odd output in restore mode From: Simon Riggs To: Tom Lane Cc: Martin Zaun , Bruce Momjian , Heikki Linnakangas , Andrew Dunstan , Dave Page , List pgsql-patches , PostgreSQL-development In-Reply-To: <792.1217019537@sss.pgh.pa.us> References: <200807011520.m61FKhZ20311@momjian.us> <48867904.9090001@sun.com> <1217015178.3894.992.camel@ebony.2ndQuadrant> <398.1217017886@sss.pgh.pa.us> <1217019182.3894.1007.camel@ebony.2ndQuadrant> <792.1217019537@sss.pgh.pa.us> Content-Type: text/plain Date: Fri, 25 Jul 2008 22:25:01 +0100 Message-Id: <1217021101.3894.1025.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 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: 200807/1222 X-Sequence-Number: 121482 On Fri, 2008-07-25 at 16:58 -0400, Tom Lane wrote: > Simon Riggs writes: > > On Fri, 2008-07-25 at 16:31 -0400, Tom Lane wrote: > >> I thought the latest conclusion was that changing the behavior of > >> pg_standby itself wouldn't address the problem anyway, and that what we > >> need is just a docs patch recommending that people use safe copying > >> methods in their scripts that copy to the archive area? > > > Plus the rest of this patch, which is really very simple. > > Why? AFAICT the patch is just a kluge that adds user-visible complexity > without providing a solution that's actually sure to work. First, I'm not the one objecting to the current behaviour. Currently, there is a wait in there that can be removed if you use a copy utility that sets size after it does a copy. So we agreed to make it optional (at PGCon). -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support