Database Replication: Strategies, Topologies, and What to Use When
A practical guide to PostgreSQL replication — physical vs logical, sync vs async, single-leader / multi-leader / leaderless, and replica-read rules.
postgresqldatabasedistributed-systemsreplicationarchitecture