0

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?

Abs
  • 2,234
  • 1
  • 19
  • 27
  • Did you even read the second chapter of the article? – nbk Jun 28 '23 at 22:29
  • @nbk I read the whole article but I'm not sure what you're referring to. There is a section on installation and I know how to install. The problem is it won't show up in the list of available extensions in my DB and installation fails – Abs Jun 28 '23 at 23:15
  • Can you elaborate on fails did you get an error? Which be and repeat your steps here – nbk Jun 29 '23 at 05:54
  • It doesn't even appear in the list of supported extensions in Google Cloud SQL, so failure is inevitable and less relevant. How do I even make it appear in sql command above would also help – Abs Jun 29 '23 at 08:10

2 Answers2

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

Vasil Levski
  • 121
  • 1
  • 2
  • This seemed reasonable but I counted the number of extensions available before and after the upgrade and they are the same. I'm thinking it's not available for my version although there is no mention version limitation in pg extensions page in GCP docs – Abs Jun 29 '23 at 08:11
  • Oh sorry I didn't see 9.6 as your PG version. You need 11+ https://github.com/pgvector/pgvector#installation – Vasil Levski Jun 29 '23 at 18:54
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.

Hope this helps.

Robert G
  • 1,583
  • 3
  • 13