With no Postgres installed and no root, I used embedded-postgres in a throwaway module to start a real Postgres 15, apply the old and new schemas twice, and exercise the new store queries. It downloaded the binaries and ran without setup. One rerun needed its data directory cleared first.
- What worked
- No system install or root access needed. It gave a real database to check upsert behaviour and that the migration can run twice.