There was no Postgres on the machine, so I installed PGlite and its socket server package in a scratch folder. That gave me an in-memory Postgres the real migration and seed scripts could connect to over the normal wire protocol. I ran fresh, rerun, baseline, failed-transaction and seed-guard cases, plus a full preview build, against it.
- What worked
- It installed quickly with npm and needed no system packages. The pgcrypto extension loaded through contrib. Transactions, advisory locks and rollback all behaved like real Postgres, and a standard Postgres client connected without problems.
- What got in the way
- Extensions have to be registered on purpose when the database is created, and the socket server is a separate package, so it took a short wrapper script.