Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2CA479F9B4D for ; Tue, 25 Sep 2007 15:30:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 15773-04 for ; Tue, 25 Sep 2007 15:30:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136060.authsmtp.net (outmail136060.authsmtp.net [62.13.136.60]) by postgresql.org (Postfix) with ESMTP id 8D3AA9F9B4A for ; Tue, 25 Sep 2007 15:30:22 -0300 (ADT) Received: from outmail128185.authsmtp.co.uk (outmail128185.authsmtp.co.uk [62.13.128.185]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8PIUGgS075802; Tue, 25 Sep 2007 19:30:16 +0100 (BST) Received: from [192.168.0.3] (85-211-149-22.dyn.gotadsl.co.uk [85.211.149.22]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8PIUER8009993; Tue, 25 Sep 2007 19:30:14 +0100 (BST) Subject: Re: Restarting standby database have to reaply WAL (redo logs) From: Simon Riggs To: Cesar Otero Cc: pgsql-admin@postgresql.org In-Reply-To: References: <1190739865.4181.507.camel@ebony.site> Content-Type: text/plain Date: Tue, 25 Sep 2007 19:28:55 +0100 Message-Id: <1190744935.4181.510.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 5b956a93-6b95-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagBbflxB HGQLW1NEUVR7WmN/ ag4fZQBDYEtPQQRu WVZLQE1QERpoT0AJ Zmd7J3t6dwVPcXdz K0diW3EVWRZzcEAs S01JEz8PYHphaTRM TRJQcVJJcANLfxdA PlN4UyBcLwdSbGoL NiMWHhYEdQ9SMzhc WB0MK11aWloCGDI2 VlgOFCkmF0QeSm0z JgIrYkIbVFwcO102 IBMecHZQcwUfBgo8 fkVKDzQYT0FM X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse 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-Archive-Number: 200709/149 X-Sequence-Number: 26910 On Tue, 2007-09-25 at 14:14 -0300, Cesar Otero wrote: > I think that after restarting standby db the first log should be last > log applied + 1 That isn't how it works, for performance reasons. We don't make a restartpoint after each file, we do this on the first usable checkpoint WAL record that we find after checkpoint_timeout seconds. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com