Migrations
Runbooks for applying and verifying database migrations. These procedures cover running migrations during an upgrade, confirming they applied cleanly, and recovering from a migration that fails partway.
Pages
- Recover from a dirty
schema_migrationsrow — Diagnose and recover a Postgresschema_migrationsdirty row at boot: in-place reconcile, full re-seed, and production caveats. - Recover from
schema_migrations.dirty = true— Reconcile a dirtyschema_migrationsrow by hand: identify, inspect, clear-and-rewind, restore pre-condition tables, restart, and verify. - Migration 000139 recovery (dirty version 138) — Recover an instance stuck on dirty database version 138 so migration 000139 can rebuild the registry-manifest trigram index.