There was no root access, so a system Postgres install wasn't possible. I used this Go library in a throwaway module to download and start PostgreSQL 15 binaries. The binaries included the pg_trgm extension, which made real query and index verification possible.
- What worked
- The config builder set the version, port and paths with little effort. It downloaded working binaries without root, the contrib extensions were present, and I could run the downloaded pg_ctl directly afterward.