Horton
Menu

Re: Synchronous replication

Fujii Masao <masao.fujii@gmail.com>

View thread
From: Fujii Masao <masao.fujii@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Greg Stark <gsstark@mit.edu>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Joshua Tolley <eggyknap@gmail.com>, Yeb Havinga <yebhavinga@gmail.com>, Aidan Van Dyk <aidan@highrise.ca>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-08-02T11:06:28Z
Lists: pgsql-hackers 
On Mon, Aug 2, 2010 at 7:53 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Let's not get *the manner of specifying the policy* confused with *the
> need to update the policy when the master changes*.  It doesn't seem
> likely you would want the same value for  synchronous_standbys on all
> your machines.  In the most common configuration, you'd probably have:
>
> on A: synchronous_standbys=B
> on B: synchronous_standbys=A

Oh, true. But, what if we have another synchronous standby called C?
We specify the policy as follows?:

on A: synchronous_standbys=B,C
on B: synchronous_standbys=A,C
on C: synchronous_standbys=A,B

We would need to change the setting on both A and B when we want to
change the name of the third standby from C to D, for example. No?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center