Setup
Base backup (pg_basebackup). Configure primary + standby. WAL streaming continuous.
Advertisement
Async vs sync
Async: primary commits before replica ack. Fast, slight data loss risk. Sync: wait for replica ack. Zero data loss + latency.
Advertisement
Cascading
Replica can serve as source for other replicas. Reduces primary bandwidth. Common at scale.