Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 820156501D0; Fri, 25 Jul 2008 17:46:37 -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 11612-02; Fri, 25 Jul 2008 17:46:30 -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-3.mail.uk.tiscali.com (mk-outboundfilter-3.mail.uk.tiscali.com [212.74.114.23]) by postgresql.org (Postfix) with ESMTP id 5CE106501CA; Fri, 25 Jul 2008 17:46:33 -0300 (ADT) X-Trace: 149354832/mk-outboundfilter-1.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: AkcBACzYiUhV0+Wb/2dsb2JhbAAIsA0 X-IronPort-AV: E=Sophos;i="4.31,253,1215385200"; d="scan'208";a="149354832" 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 21:46:30 +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: <398.1217017886@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> Content-Type: text/plain Date: Fri, 25 Jul 2008 21:53:02 +0100 Message-Id: <1217019182.3894.1007.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/1219 X-Sequence-Number: 121479 On Fri, 2008-07-25 at 16:31 -0400, Tom Lane wrote: > Simon Riggs writes: > > On Tue, 2008-07-22 at 17:19 -0700, Martin Zaun wrote: > >> reviewing your patch > > > Current status is this: > > * My understanding is that Dave and Andrew (and therefore Simon) think > > the approach proposed here is an acceptable one. Heikki disagrees and > > wants different approach. Perhaps I misunderstand. > > * Patch needs work to complete the proposed approach > > * I'm willing to change the patch, but not able to test it on Windows. > > 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. pg_standby currently waits (on Windows) for the sleep time. We agreed that this sleep would be on by default, but optional. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support