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 |