PostgreSQL streaming replication setup, synchronous vs asynchronous tradeoffs, logical replication for selective sync and zero-downtime upgrades, pg_basebackup for standby creation, Patroni with etcd for automatic failover, pg_rewind for rejoining a former primary, and monitoring replication lag.
Patroni
-
PostgreSQL Replication and High Availability