Skip to content

migrations: Add (rudimentary) docs for rollback

Administrator requested to merge ef/migrator-version into main

Created by: efritz

This PR adds:

  • a validate command to both sg migration and the migrator service, which simply runs the validation routine that the applications do on startup, and exits with a status of zero if the database is clean and up to date and one otherwise.
  • a leaves command to sg migration which takes a commit and returns the last migrations defined at that time.
  • documentation on how to roll back a postgres database with these two new tools

Reviewers: Please give special attention to the doc page and suggest where I can steal copy from other migrations work we've been doing lately.

Edit: Non-docs work was pulled out into #30860.

Merge request reports