supabase / postgres

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

Adds a Wasm wrapper test script for pg_dumpall and pg_upgrade testing #1095

Open olirice opened 1 month ago

olirice commented 1 month ago

Creates a test script that can be used for evaluating if a pause/restore will work.

We should be able to execute it using

OLD_GIT_VERSION=47d598f6be65cd5b920ae807cf98c401ed5ae045
NEW_GIT_VERSION=47d598f6be65cd5b920ae807cf98c401ed5ae045

nix run github:supabase/nix-postgres#migration-test \
  $(nix build "github:supabase/nix-postgres/$OLD_GIT_VERSION#psql_15/bin") \
  $(nix build "github:supabase/nix-postgres/$NEW_GIT_VERSION#psql_15/bin") \
  pg_dumpall

but it is currently not functional. Opening as a draft so we can evaluate how to fix it

The error is

error: flake 'github:supabase/nix-postgres' does not provide attribute 'apps.aarch64-darwin.migration-test', 'packages.aarch64-darwin.migration-test', 'legacyPackages.aarch64-darwin.migration-test' or 'migration-test'