Postgres Migration Stuck on ALTER TABLE in Production
An ALTER TABLE migration hangs forever on prod. Find the blocker with pg_blocking_pids, terminate it, and re-run with a lock_timeout so it fails fast instead of stalling.
#Migration
Articles tagged with #Migration
Database Migration Review Prompts for Safe Schema Changes
12 migration review prompts that catch table-locking ALTERs, backfill races, and silent column drops across Postgres, MySQL, and SQLite. Tested against Opus 4.7 and GPT-5.5.
Migration Plan Prompts: 12 Templates for Framework / DB / Auth Moves
12 migration prompts that produce a real phased plan with rollback at every step, not "rewrite everything". Covers Next.js App Router, Postgres, auth swaps, monolith→service, monorepo.