supabase / postgres

Unmodified Postgres with some useful plugins
https://supabase.com
PostgreSQL License
1.39k stars 139 forks source link

Sam/migration testing #1173

Closed samrose closed 2 months ago

samrose commented 2 months ago

What kind of change does this PR introduce?

Migration testing that aligns with the workflow here but able to run locally against 2 versions of pg (currently just 15 -> 15)

This test is run with nix run .#migration-test <git-tag-only> gitsha-or-gittag> pg_upgrade

We'll deprecate the "major version" as it is too vague to meaningful for the use cases for this tool.

This PR is WIP/Draft at this point, but prior to merging, we'll create specific tags for building and testing previous versions, and retain those in the git repo, and implement the support for gitsha or tag.

samrose commented 2 months ago

closing in favor of https://github.com/supabase/postgres/pull/1183