--- title : " Zero Downtime Database Migrations: A Practical Guide for PostgreSQL" published : true description : " Step-by-step guide to performing schema migrations in PostgreSQL without downtime — covering ALTER TABLE tricks, CREATE INDEX CONCURRENTLY, safe renames, and migration tooling." tags : postgresql, architecture, devops, cloud canonical_url : https://blog.mvpfactory.co/zero-downtime-database-migrations-postgresql ---

## What We're Building

In this workshop, I'll walk you through the exact patterns I use in production to run PostgreSQL schema migrations with zero downtime.…