How to enable pgvector extension in postgres flexible server

Question

How to enable pgvector extension in postgres flexible server

Jonathan Prom Scharff 30

According to this then the pgvector extension should be available for the azure postgres flexible server.

The extension is, however, not available through the azure portal GUI nor is it possible to enable the extension through the azure bash cli - following the guidelines outlined here.

Am I missing something or is the pgvector extension not available yet?

0 comments

Answer accepted by question author

SSingh-MSFT 16,461 Moderator

Hi Jonathan Prom Scharff •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to use pgvector extension in Azure Database for PostgreSQL.

Could you please open Azure Database for PostgreSQL flexible server-> Server Parameters-> Search for azure.extensions -> Enable Vector as shown below:

User's image

Please try and let us know if you face any issue.

If not able to perform, please share us the configuration details of the flexible server so that we can further investigate.

Thank you.

SSingh-MSFT 16,461 Reputation points Moderator

2023-05-23T10:43:31.4233333+00:00

Hi Jonathan Prom Scharff •,

An update: This feature is under our roadmap, ETA is CY23Q2, and to be more accurate it will be after the end of the current deployment (M28), for newly created servers it will be there as shown above for the server and for existing servers it will be in early June.

Thank you.
Jonathan Prom Scharff 30 Reputation points

2023-05-23T11:30:23.9666667+00:00

Ahh, I am trying to add the pgvector extension to an existing server, which is why the extension does not show up. I'll create a new database server and migrate data to that one so I can start experiment with the pgvector extension.

Thanks a lot for the quick answer!. :-)
Jonathan Prom Scharff 30 Reputation points

2023-05-23T11:32:43.14+00:00

Ahh, I have been trying to add the pgvector extension to an existing postgres server, which is why the extension did not appear.
I'll wait until start of june for existing production databases and create a new server to play around with the extension.

Thanks a lot for the quick answer!. Really appreciate it :-).
Kaja Kandare 25 Reputation points

2023-05-26T09:18:31.6533333+00:00

Hi!
On May 19th, I successfully deployed Azure Database for PostgreSQL flexible server and added the vector extension. I utilized the development workload type and used PgAdmin as the client. I created an extension for the vector (refer to the image below).

However, whenever I attempted to run a query using the vector extension, I encountered a "Connection Warning" (see image below). Running other queries works fine.

Could you please assist me in finding a solution? Thank you.

1 additional answer

Your answer

SSingh-MSFT 16,461 Reputation points Moderator

2023-05-23T10:43:31.4233333+00:00

Hi Jonathan Prom Scharff •,

An update: This feature is under our roadmap, ETA is CY23Q2, and to be more accurate it will be after the end of the current deployment (M28), for newly created servers it will be there as shown above for the server and for existing servers it will be in early June.

Thank you.
Jonathan Prom Scharff 30 Reputation points

2023-05-23T11:30:23.9666667+00:00

Ahh, I am trying to add the pgvector extension to an existing server, which is why the extension does not show up. I'll create a new database server and migrate data to that one so I can start experiment with the pgvector extension.

Thanks a lot for the quick answer!. :-)
Jonathan Prom Scharff 30 Reputation points

2023-05-23T11:32:43.14+00:00

Ahh, I have been trying to add the pgvector extension to an existing postgres server, which is why the extension did not appear.
I'll wait until start of june for existing production databases and create a new server to play around with the extension.

Thanks a lot for the quick answer!. Really appreciate it :-).
Kaja Kandare 25 Reputation points

2023-05-26T09:18:31.6533333+00:00

Hi!
On May 19th, I successfully deployed Azure Database for PostgreSQL flexible server and added the vector extension. I utilized the development workload type and used PgAdmin as the client. I created an extension for the vector (refer to the image below).

However, whenever I attempted to run a query using the vector extension, I encountered a "Connection Warning" (see image below). Running other queries works fine.

Could you please assist me in finding a solution? Thank you.

Answer 1

SSingh-MSFT 16,461 Moderator

Hi Kaja Kandare •,

We are sorry about the inconvenience.

This feature is under our roadmap, ETA is CY23Q2, and to be more accurate it will be after the end of the current deployment (M28), for newly created servers it will be there as shown above for the server and for existing servers it will be in early June.

Kindly check if your server is existing or a new one.

Accordingly, you are requested to wait until the ETA to get this extension functioning.

Thank you.

0 comments

Share via

How to enable pgvector extension in postgres flexible server

1 additional answer

Your answer