Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 734B0635F1F for ; Fri, 2 Oct 2009 05:05:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 60736-02 for ; Fri, 2 Oct 2009 08:05:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128144.authsmtp.com (outmail128144.authsmtp.com [62.13.128.144]) by mail.postgresql.org (Postfix) with ESMTP id AB22E635F0C for ; Fri, 2 Oct 2009 05:04:24 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt10.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9284KVj036357; Fri, 2 Oct 2009 09:04:20 +0100 (BST) Received: from [192.168.0.5] (88-110-190-77.dynamic.dsl.as9105.com [88.110.190.77]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9284HpU030063; Fri, 2 Oct 2009 09:04:18 +0100 (BST) Subject: Re: Hot Standby on git From: Simon Riggs To: Heikki Linnakangas Cc: pgsql-hackers In-Reply-To: <4AC5AF36.3020900@enterprisedb.com> References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4AC2FBB9.7060304@enterprisedb.com> <1254408330.17864.233.camel@ebony.2ndQuadrant> <4AC4CF18.50309@enterprisedb.com> <1254413624.17864.243.camel@ebony.2ndQuadrant> <4AC5A60F.5050503@enterprisedb.com> <1254468966.17864.301.camel@ebony.2ndQuadrant> <4AC5AF36.3020900@enterprisedb.com> Content-Type: text/plain Date: Fri, 02 Oct 2009 09:07:54 +0100 Message-Id: <1254470874.17864.309.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 2f3815dc-af2a-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAdbYlpF HGQLW11EUFR7WWd/ agIfZQ1DY0tOQQRj UFZORU1QEQdtHhxP WBccWh0KN2BGe35w Y0UsXHRTXAp4I0V1 Q0sARnBXM2UxdWEe BBVFfgMHJB5Kfh1H bFR2U3sIYG1JBC9q VzwTFhsSEA9kHWx1 RR1FFk4bR0oBD3Y7 QVgNHClH X-Authentic-SMTP: 61633235383639.1014:706/Kp X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.582 tagged_above=-10 required=5 tests=AWL=0.017, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/142 X-Sequence-Number: 146954 On Fri, 2009-10-02 at 10:43 +0300, Heikki Linnakangas wrote: > It seems dangerous to write a WAL record after the shutdown checkpoint. > It will be overwritten by subsequent startup, which is a recipe for trouble. I've said its a corner case and not worth spending time on. I'm putting it in at your request. If it's not correct before and not correct after, where exactly do you want it? -- Simon Riggs www.2ndQuadrant.com