Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B5B3A7983A0 for ; Wed, 17 Mar 2010 07:49:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 62096-06 for ; Wed, 17 Mar 2010 10:49:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail129158.authsmtp.com (outmail129158.authsmtp.com [62.13.129.158]) by mail.postgresql.org (Postfix) with ESMTP id E59DD797C8C for ; Wed, 17 Mar 2010 07:49:26 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2HAnHdT062142; Wed, 17 Mar 2010 10:49:17 GMT Received: from [192.168.0.4] (88-110-151-22.dynamic.dsl.as9105.com [88.110.151.22]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2HAnCn6002951; Wed, 17 Mar 2010 10:49:13 GMT Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL From: Simon Riggs To: Heikki Linnakangas Cc: Fujii Masao , Aidan Van Dyk , PostgreSQL-development In-Reply-To: <4BA0B079.3050301@enterprisedb.com> References: <3f0b79eb1002092105r21e009d3v468496058ba04392@mail.gmail.com> <4B73F678.8070109@enterprisedb.com> <1265891248.7341.1346.camel@ebony> <4B73FB99.4080403@enterprisedb.com> <1265893599.7341.1454.camel@ebony> <4B740613.5090004@enterprisedb.com> <20100211140118.GB14128@oak.highrise.ca> <4B74118C.30704@enterprisedb.com> <20100211144204.GC14128@oak.highrise.ca> <4B743E7D.5070603@enterprisedb.com> <3f0b79eb1002180337t1fab1395ve3491256672af15f@mail.gmail.com> <4BA0B079.3050301@enterprisedb.com> Content-Type: text/plain Date: Wed, 17 Mar 2010 10:49:11 +0000 Message-Id: <1268822951.3825.16607.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: b9c2ae52-31b2-11df-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaQJbYFhD HGQLWlREUV17XWp/ agkfZQ1DY0tOQQRv UVZLQE1XHAJ3AVJe BGZvDGoscQVGend1 ZAhkWHZbEhZzJkQs F0tWCG4HN2V9aWFL Bl1RcFEGbQNKfB1D bll4XHYMaStlM3Bw LC8aFBMcBw5qYB5Y EEk+BnU3ZGc3IhMG fCVKBTo0BElXDwA6 LBFuMUIVGkobIw0p PEE/VEhQUVcZDQtC HkdQBzJCI0hJXSc3 FxISR0MFDDpHQCFT SgEoL1dODyxOEhVx ICMA X-Authentic-SMTP: 61633235383639.1014:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-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.412 tagged_above=-10 required=5 tests=AWL=0.187, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/683 X-Sequence-Number: 159459 On Wed, 2010-03-17 at 12:35 +0200, Heikki Linnakangas wrote: > Looking into this, I realized that we have a bigger problem... A lot of this would be easier if you do the docs first, then work through the problems. The new system is more complex, since it has two modes rather than one and also multiple processes and a live connection. The number of failure cases must be higher than previously. Documenting how it is supposed to work in the event of failure will help everyone check those and comment on them. -- Simon Riggs www.2ndQuadrant.com