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?
Based on this documentation on pgvector installation:
Compile and install the extension (supports Postgres 11+)
It is also mentioned through this changelog:
0.3.0 (2022-10-15)
- Added support for Postgres
15- Dropped support for Postgres
9.6
Meaning that the minimun Postgres version should be at least 11 or higher. I've tried installing the extension using version 9.6 and 10, 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.