Re: standby registration (was: is sync rep stalled?) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: standby registration (was: is sync rep stalled?)
Date
Msg-id AANLkTinzEP8KO6h5Zi18EzSwC9S-aa92YJccpW79g+so@mail.gmail.com
Whole thread Raw
In response to Re: standby registration (was: is sync rep stalled?)  (Markus Wanner <markus@bluegap.ch>)
Responses Re: standby registration (was: is sync rep stalled?)
Re: standby registration (was: is sync rep stalled?)
List pgsql-hackers
On Mon, Oct 4, 2010 at 1:57 PM, Markus Wanner <markus@bluegap.ch> wrote:
> On 10/04/2010 05:20 PM, Robert Haas wrote:
>> Quorum commit, even with configurable vote weights, can't handle a
>> requirement that a particular commit be replicated to (A || B) && (C
>> || D).
>
> Good point.
>
> Can the proposed standby registration configuration format cover such a
> requirement?

Well, if you can name the standbys, there's no reason there couldn't
be a parameter that takes a string that looks pretty much like the
above.  There are, of course, some situations that could be handled
more elegantly by quorum commit ("any 3 of 5 available standbys") but
the above is more general and not unreasonably longwinded for
reasonable numbers of standbys.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Tomoaki Sato
Date:
Subject: Re: pgadmin3_90 package
Next
From: Robert Haas
Date:
Subject: Re: Basic JSON support