[aliqot]

Either I'm the guy setting up all the vulnerable Postgres installs or I'm just some kind of unknown Postgres savant.

Cany anybody help me out and mention some setup details a blissful idiot like myself might be neglecting in their postgres cluster-ups?

[CodesInChaos]

How do you handle replication and failover?

The cluster of 3+ servers must remain consistent, available, and not lose committed transactions when a minority of servers (including the former master) fails.

[com]

I’ve had good experiences with logical replication and pg_auto_failover. The cool thing is that the libpq-based clients do some of the work during failovers. You’ll need three nodes though.