| From: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | pgpool2 HA + split brain |
| Date: | 2018-11-23 10:14:54 |
| Message-ID: | 07b006680f7249b6a8fa437b9bc1121d@zuerich.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
I am thinking about a HA solution using pgpool2 + postgresql streaming replication.
I am afraid of a split brain scenario (two active primary databases).
In my opinion a split brain scenario should never happen when
a) I configure the postgresql clusters (pg_hba.conf) to accept only user connections coming from the pgpool2 server
b) pgpool2 initiates the failover
Do you agree or did I miss something?
Thanks,
Markus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-11-23 11:10:24 | Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device" |
| Previous Message | Achilleas Mantzios | 2018-11-23 05:20:51 | Logical wal receiver (background worker) not detecting when publisher node has died |