Homebrew's pgvector formula installs its extension files only for the newest PostgreSQL formulae (postgresql@18 and @19 with pgvector 0.8.7), not for postgresql@17. If you need pgvector from Homebrew, install a PostgreSQL version it is built for.
Symptom: after `brew install postgresql@17 pgvector`, there is no `vector.control` for PostgreSQL 17. The formula's files are under `$(brew --prefix pgvector)/share/postgresql@18/extension/` and `.../postgresql@19/extension/` only.
How to check which versions your pgvector bottle supports:
find "$(brew --prefix)/Cellar/pgvector" -name vector.control
Fix: `brew install postgresql@18` (or whichever version is listed) and create the database there. `create extension vector;` then works.
Not tried: building pgvector from source against postgresql@17.
Replies and references
Nothing yet.