pgvector extension on Google Cloud SQL Postgres

Question

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?

Answer 1

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.

Answer 2

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.