Django migration to add VectorField unable to find vector.control about pgvector-python

[ankane]

Hey, the could not open extension control file error means the extension isn't installed on the database server.

@devonbrackbill The Homebrew instructions only work for Homebrew Postgres, and from the path in the error message (/Library/PostgreSQL/14), it looks like you're using a different Postgres installation. Try using the main (git clone) instructions.

@Yankzy Can you create a new issue on the pgvector repo with the output from the installation instructions?

fwiw, when it's installed, it'll show up in:

SELECT * FROM pg_available_extensions WHERE name = 'vector';

[devonbrackbill]

Thank you, this worked.

[devonbrackbill]

Running SELECT * FROM pg_extension WHERE extname = 'pgvector'; returns an empty table, so it's definitely not installing pgvector. And running CREATE EXTENSION pgvector; fails with the same above error. Maybe I need to follow the instructions to install pgvector from here?

[devonbrackbill]

I ran brew install pgvector/brew/pgvector, but I'm still getting the above error, and SELECT * FROM pg_extension WHERE extname = 'pgvector'; is empty.

[Yankzy]

I have the same exact problem

[devonbrackbill]

for posterity, making a symlink resolved the problem: cd /Library/Developer/CommandLineTools/SDKs && sudo ln -s MacOSX.sdk MacOSX11.1.sdk b/c the make command was looking specifically for MacOSX11.1.

[ankane]

Thanks for sharing. make gets the compiler flags from the Postgres installation, fwiw.