Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 564931337B5C
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Tue,  4 Jan 2011 15:50:41 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 53108-09
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Tue,  4 Jan 2011 19:50:34 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cronos.madness.at (madness.at [217.196.146.217])
	by mail.postgresql.org (Postfix) with ESMTP id E50A21337B39
	for <pgsql-hackers@postgresql.org>;
	Tue,  4 Jan 2011 15:50:33 -0400 (AST)
Received: from gatekeeper.kaltenbrunner.cc ([83.215.243.9]
 helo=[192.168.8.22])
	by cronos.madness.at with esmtpsa (TLS1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.69) (envelope-from <stefan@kaltenbrunner.cc>)
	id 1PaCtf-00081F-Oc; Tue, 04 Jan 2011 20:50:21 +0100
Message-ID: <4D2379F9.2000901@kaltenbrunner.cc>
Date: Tue, 04 Jan 2011 20:50:17 +0100
From: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.15) Gecko/20101030 Iceowl/1.0b1 Icedove/3.0.10
MIME-Version: 1.0
To: Simon Riggs <simon@2ndQuadrant.com>
CC: Josh Berkus <josh@agliodbs.com>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	Robert Haas <robertmhaas@gmail.com>,
	Hannu Krosing <hannu@2ndquadrant.com>,
	greg@2ndquadrant.com, pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
References: <1293729972.1892.23804.camel@ebony>	
	<4D1CC47E.7050207@kaltenbrunner.cc>
	<1293735853.1892.24886.camel@ebony>	
	<AANLkTi=SvN2KQ1Tzh-tRKcXD0i2FyWFBbbR=kXXdepqN@mail.gmail.com>	
	<4D1D8B2F.5070001@2ndquadrant.com>
	<4D1DAB14.5000800@enterprisedb.com>	
	<1293796137.1892.37313.camel@ebony>
	<4D1DCF5A.7070808@enterprisedb.com>	
	<4D1E4897.1050400@2ndquadrant.com>
	<1293882875.1892.56143.camel@ebony>	
	<AANLkTi=yYKvRCvfTprbj=jQDVMrDKUMcate=vCaQobSi@mail.gmail.com>	
	<1293975673.2090.464.camel@ebony>
	<4D20ADC5.7070804@enterprisedb.com>	
	<1294003186.2090.3338.camel@ebony> <4D2366CE.1010705@agliodbs.com>
	<1294167105.19612.8276.camel@ebony>
In-Reply-To: <1294167105.19612.8276.camel@ebony>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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: 201101/273
X-Sequence-Number: 178110

On 01/04/2011 07:51 PM, Simon Riggs wrote:
> On Tue, 2011-01-04 at 10:28 -0800, Josh Berkus wrote:
>
>> The relevant question is: which configuration(s) can we have ready for
>> the next CommitFest and alpha release?
>
> Based upon that series of conversations, I've reworked the design so
> that there is (currently) only a single standby offering sync rep at any
> one time. Other standbys can request to be sync standbys but they only
> become the sync standby if the first one fails. Which was simple to do
> and bridges the challenges of an exactly identified sync standby and the
> fragility of too closely specifying the config.

ah cool - like that approach for 9.1!


Thanks for working on that!


Stefan