PostgreSQL-v13-Repmgr: Split-Brain issue

From: Amit Sharma <amitpgsql(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL-v13-Repmgr: Split-Brain issue
Date: 2024-08-09 15:40:28
Message-ID: CAHER7Lpb38HFMLF-qQPDGNuHJHe4=wETAiYBbiM6V-QK7qjxbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have PosgreSQL primary and a local standby(same data center) and a remote
standby for DR purposes. Currently repmgr is enabled on the same servers
for an automatic failover but it's running into split brain issues.

I have two questions:

1. In order to avoid split-brain between primary and local standby, can
repmgr be set up on a separate witness node to help provide fencing or
prevent a split brain?
2. If so, can I use the same witness server for multiple sets of primary
and secondary postgresql servers/clusters? like one witness server for one
environment that can have multiple postgreSQL clusters? Is there any
document available for that configuration?

Thanks
Amit

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Serrano 2024-08-09 17:38:00 Re: PostgreSQL - A method to control Resource Consumptions of Users or process
Previous Message PABLO ANDRES IBARRA DUPRAT 2024-08-09 14:25:54 PostgreSQL - A method to control Resource Consumptions of Users or process