PostgreSQL Zero Downtime Migration: Expand and Contract in Practice
Run PostgreSQL schema changes without outages: lock_timeout with retries, expand and contract steps, batched backfills, NOT VALID constraints and concurrent indexes.
14 min read
Tag
Run PostgreSQL schema changes without outages: lock_timeout with retries, expand and contract steps, batched backfills, NOT VALID constraints and concurrent indexes.
14 min read
Build blue/green zero downtime deployments on one host with Docker Compose healthchecks, Nginx upstream switching, graceful reloads, and safe rollback.
17 min read
Learn how expand and contract keeps schema migrations backward compatible during rolling deploys, with PostgreSQL lock, backfill and rollback techniques.
13 min read