Google Cloud SQL recently announced support for Postgres extension pgvector. But it’s not available in the list of extensions supported SELECT * FROM pg_available_extensions;
. I’m on version 9.6. What do I need to do to see the extension?
Question posted in PostgreSQL
The official documentation can be found here.
The official documentation can be found here.
2
Answers
You have to get to the latest cloud sql pg maintenance version.
If you select your instance you can manually update in the maintenance panel.
Based on this documentation on
pgvector
installation:It is also mentioned through this changelog:
Meaning that the minimun Postgres version should be at least
11
or higher. I’ve tried installing the extension using version9.6
and10
, both unsuccessful.If you really want this version to be available, you may either use Postgres version
11
or higher or file this as a feature request through this link.Hope this helps.