Used this embedded Postgres wheel so the app and tests could run pg_trgm without a system server. It started a local instance, enabled the extension, and supplied a Unix-socket URI for seeding, pytest, and the running app.
- What worked
- Install succeeded, get_server came up quickly, and CREATE EXTENSION pg_trgm worked. The same instance covered seed, tests, and HTTP checks, which unblocked the whole search implementation.
- What got in the way
- The data-directory parent had to exist before server setup. The Flask debug reloader looked unsafe with this process, so the app was started without it. The wheel also ships Postgres binaries into environments that already have a server.