Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B39401337B7E for ; Thu, 30 Dec 2010 21:08:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 10723-04 for ; Fri, 31 Dec 2010 01:07:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149043.authsmtp.co.uk (outmail149043.authsmtp.co.uk [62.13.149.43]) by mail.postgresql.org (Postfix) with ESMTP id 5A3361337B61 for ; Thu, 30 Dec 2010 21:07:56 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id oBV17t5T089702; Fri, 31 Dec 2010 01:07:55 GMT Received: from [192.168.0.2] ([81.5.146.37]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id oBV17spQ062037; Fri, 31 Dec 2010 01:07:54 GMT Subject: Re: Sync Rep Design From: Simon Riggs To: Robert Haas Cc: pgsql-hackers@postgresql.org In-Reply-To: References: <1293729972.1892.23804.camel@ebony> <4D1CC47E.7050207@kaltenbrunner.cc> <1293735853.1892.24886.camel@ebony> Content-Type: text/plain; charset="UTF-8" Date: Fri, 31 Dec 2010 01:07:53 +0000 Message-ID: <1293757673.1892.28980.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Server-Quench: 65b736b3-147a-11e0-ab46-001185d377ca X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFawRbaVxS HGQLWlREUFx7WWR/ bg4fZQRDZ1RPWwN0 U09WR1pVCwUmXm5n BxldEnhycQdGe3k+ Z09nWD5dWRZ9dkAv QVNVEWpXeGZhPWAC ARJccR5UcAJLdhoR aVd4ByJDAzANdhEY NiQQEgoKCH1kOSJe CjsANRo+TF0KEThU X-Authentic-SMTP: 61633235383639.1000:706 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=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201012/2515 X-Sequence-Number: 177777 On Thu, 2010-12-30 at 16:27 -0500, Robert Haas wrote: > I think it's a bad idea to use the same parameter to mean different > things on the master and standby. Obviously if you phrase it like that, nobody would disagree. I would say I have used the same parameter on both sides in a balanced way to simplify the configuration, which had been an important factor in the debate. "You need to set parameter X on both primary and standby" seems simple and clear. It certainly works OK for MySQL. It's no bother to change, whichever way we decide and I'm happy to do so. My previous patch had two parameters: primary: synchronous_replication = ... standby: synchronous_replication_service = on | off Which do people prefer? -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services