Zero Downtime Database Migrations: A Practical Guide for PostgreSQL
Step-by-step guide to performing schema migrations in PostgreSQL without any downtime. Cover ALTER TABLE tricks, CREATE INDEX CONCURRENTLY, adding columns with defaults, renaming via views, and real-world migration scripts.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3790305) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } SoftwareDevs mvpfactory.io Posted on May 1 • Originally published at mvpfactory.io Zero Downtime Database Migrations: A Practical Guide for PostgreSQL #webdev #programming --- 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,…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
