Re: DRAFT 9.6 release - Mailing list pgsql-advocacy

From Josh Berkus
Subject Re: DRAFT 9.6 release
Date
Msg-id ce760237-e85e-3a5c-f85b-c96510b8990e@agliodbs.com
Whole thread Raw
In response to DRAFT 9.6 release  (Josh Berkus <josh@agliodbs.com>)
Responses Re: DRAFT 9.6 release  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-advocacy
On 08/30/2016 06:51 PM, Michael Paquier wrote:
> On Wed, Aug 31, 2016 at 10:45 AM, Josh Berkus <josh@agliodbs.com> wrote:
>> On 08/30/2016 06:39 PM, Michael Paquier wrote:
>>> On Wed, Aug 31, 2016 at 10:35 AM, Josh Berkus <josh@agliodbs.com> wrote:
>>>> ??? It's always been possible for me to give multiple standbys the same
>>>> name, making a de-facto group.
>>>
>>> A "group" grammar, by that I mean an alias referring to a set of
>>> nodes, is not supported. And you can still define multiple entries
>>> with the same name.
>>>
>>
>> Yeah, so what happens in the case I described?  Is the master just
>> looking for that number of commits, or is it looking for a commit from
>> g1 and from g2?
>
> How do you set up synchronous_standby_names in this case? Are multiple
> nodes using the same application_name, being either 'g1' or 'g2'?
>

Correct.

The other question I have is:  presumably if s2 does not respond within
a certain amount of time, it times out and is marked "disconnected", no?
 So the main way this is inferior to true quorum commit is that (a) we
wait for that and (b) if s2 is busy but not unresponsive, we wait
forever.  No?

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


pgsql-advocacy by date:

Previous
From: Michael Paquier
Date:
Subject: Re: DRAFT 9.6 release
Next
From: Michael Paquier
Date:
Subject: Re: DRAFT 9.6 release