Re: Support for N synchronous standby servers - take 2 - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Support for N synchronous standby servers - take 2
Date
Msg-id 5594E54E.6010403@lab.ntt.co.jp
Whole thread Raw
In response to Re: Support for N synchronous standby servers - take 2  (Beena Emerson <memissemerson@gmail.com>)
List pgsql-hackers
On 2015-07-02 PM 03:43, Beena Emerson wrote:
> Amit wrote:
> 
>> Does HA software determine a standby to promote based on replication
>> progress 
>> or would things be reliable enough for it to infer one from the quorum
>> setting 
>> specified in GUC (or wherever)? Is part of the job of this patch to make
>> the 
>> latter possible? Just wondering or perhaps I am completely missing the
>> point.
> 
> Deciding the failover standby is not exactly part of this patch but we
> should be able to set up a mechanism to decide which is the best standby to
> be promoted. 
> 
> We might not be able to conclude this from the sync parameter alone.
> 
> As specified before in some cases an async standby could also be most
> eligible for the promotion.
> 

Thanks for the explanation.

Regards,
Amit





pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Odd behaviour of SELECT ... ORDER BY ... FOR UPDATE
Next
From: Marko Tiikkaja
Date:
Subject: Re: Odd behaviour of SELECT ... ORDER BY ... FOR UPDATE