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

From Simon Riggs
Subject Re: standby registration (was: is sync rep stalled?)
Date
Msg-id 1286282046.2025.1296.camel@ebony
Whole thread Raw
In response to Re: standby registration (was: is sync rep stalled?)  (Josh Berkus <josh@agliodbs.com>)
Responses Re: standby registration (was: is sync rep stalled?)
List pgsql-hackers
On Mon, 2010-10-04 at 12:45 -0700, Josh Berkus 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.

Asking for quorum_commit = 3 would cover that requirement.

Not exactly as requested, but in a way that is both simpler to express
and requires no changes to configuration after failover. ISTM better to
have a single parameter than 5 separate configuration files, with
behaviour that the community would not easily be able to validate.

> If this is the only feature which standby registration is needed for,
> has anyone written the code for it yet?  Is anyone planning to?

(Not me)

> If not, it seems like standby registration is not *required* for 9.1.  I
> still tend to think it would be nice to have from a DBA perspective, but
> we should separate required from "nice to have".

Agreed.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: standby registration (was: is sync rep stalled?)
Next
From: Craig Ringer
Date:
Subject: A quick warning on the win32 build scripts