Re: repmgr and STONIT - SPLIT BAIN

Hi

On 1/15/19 5:54 PM, ROS Didier wrote:
> Hi
>
> We are going to implement repmgr according to the following configuration :
>
> -Primary node on the site A
>
> -Standby node on the site B
>
> -Witness node on the same site A
>
> Do we need to use LOCATION repmgr parameter in this case to avoid Split Brain and permit STONIT ?

In this case, the "location" parameter should be the same for all nodes.

FYI the "location" parameter is intended for the use case where you have a large
number of nodes in multiple data centres and need to ensure that only a node in the
same data centre (location) as the primary can get promoted.

STONITH is something you'll need to implement yourself.

Regards

Ian Barwick

--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services