Near-Zero-Downtime Postgres Major Upgrades
pg_upgrade in link mode takes seconds. Logical replication takes planning. Here is when each wins, plus a tested Postgres 17 to 18 cutover with a rollback path.
Tag: replication
All the articles with the tag "replication".
Nominatim Diff Replication
Imported OSM data goes stale fast. Run pyosmium and Nominatim's diff replication pipeline so your geocoder stays accurate without re-importing planet.
SQLite Replication: Litestream and rqlite
Compare Litestream's continuous backup with rqlite's Raft replication for distributed SQLite. Learn when each fits your self-hosted setup.
Postgres Replication: Streaming + Logical
Postgres replication at home: when you need read replicas, streaming vs logical replication explained, slot management, conflict handling.