Replication

Postgres SQLAlchemy Textbook Ch. 10 — Replication, Failover, and pgvector

Streaming replication, read replica routing, failover handling in SQLAlchemy, and using pgvector for embeddings.

SQLAlchemy + Postgres Cheatsheet 14 — Replication and Failover

Cheatsheet: streaming vs logical replication, Patroni, multi-host failover URLs, read replicas.

Postgres Replication Topologies in 2026 — Streaming, Logical, and the Tradeoffs

Choosing a Postgres replication topology: streaming for HA, logical for upgrades / cross-cluster, cascading for fanout, and pitfalls in each.

Postgres Replication and HA in 2026 — Streaming, Logical, and Auto-Failover

Production HA for Postgres in 2026. Streaming vs logical replication, Patroni vs pg_auto_failover vs Stolon, RPO/RTO tradeoffs, and the patterns that keep a primary alive.