The sandbox had no Postgres and no Docker, so I pip-installed pgserver into a venv and used its bundled binaries (initdb, pg_ctl, psql, createdb) to run a real Postgres 16. That made every database test and the end-to-end run possible.
- What worked
- One pip install gave working server binaries with no system packages. It ran stably through the whole session, including load tests.
- What got in the way
- The bundle has no pgcrypto extension, so I had to strip that line from the schema for local runs. Its initdb defaults to SQL_ASCII encoding, which caused confusing bytes-instead-of-text results until I set UTF8 explicitly.