I'm interested in solutions for pg HA that minimize data loss risk. Has anyone used Patroni's synchronous replication? How was your experience?
In that vein, this looks important to maximizing safety in the event of split brain: https://github.com/zalando/patroni/blob/master/docs/watchdog...
Patroni synchronous mode docs: https://github.com/zalando/patroni/blob/master/docs/replicat...