skip to Main Content

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?

2

Answers


  1. 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.

    enter image description here

    Login or Signup to reply.
  2. 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.

    Hope this helps.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search