How to enable vector extension in azure cosmos db

Question

How to enable vector extension in azure cosmos db

Javier Outón 55

Hi we've been notified general availability of vector extension for Postgre DB in azure cosmos db since May. We have been following this link https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/howto-use-pgvector to enable it but we get:

citus=> SELECT CREATE_EXTENSION('vector');

ERROR: not allowed to create this extension

our version is: PostgreSQL 15.3 (Ubuntu 15.3-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.

0, 64-bit

SSingh-MSFT 16,461 Reputation points Moderator

2023-07-07T12:37:03.54+00:00

Hi
Javier Outón •,

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

As I understand, you want to know How to enable vector extension in azure cosmos db.

I hope you are referring to https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pgvector.

Similar issue was reported here in Q&A:

https://learn.microsoft.com/en-us/answers/questions/1308154/create-extension-vector-error-type-does-not-exist

Please take a look and let us know if this helped. If not, do reply so that we can further investigate.

Thanks
SSingh-MSFT 16,461 Reputation points Moderator

2023-07-10T09:11:51.4466667+00:00

Hi
Javier Outón •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Javier Outón 55 Reputation points

2023-07-10T09:16:42.9333333+00:00

Hi ShaktiSingh, thank you for your answer. Your are linking to flexible server but my scenario is cosmos-db. In cosmos DB (I think) we don't have server parameters. But as stated here https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/product-updates pgvector is availble since May 2023 for version 15 .

Javier Outón 55

One more thing. When I query the extension named 'vector' I can see vector extension.

citus=> SELECT * FROM pg_available_extensions where name = 'vector';
  name  | default_version | installed_version |                  comment
--------+-----------------+-------------------+--------------------------------------------
 vector | 0.4.1           |                   | vector data type and ivfflat access method
(1 row)

SSingh-MSFT 16,461 Reputation points Moderator

2023-07-13T04:01:04.2733333+00:00

Hi
Javier Outón •,

Thanks for the reply.

Let me check and get back to you.

2 answers

Your answer

SSingh-MSFT 16,461 Reputation points Moderator

2023-07-07T12:37:03.54+00:00

Hi
Javier Outón •,

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

As I understand, you want to know How to enable vector extension in azure cosmos db.

I hope you are referring to https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pgvector.

Similar issue was reported here in Q&A:

https://learn.microsoft.com/en-us/answers/questions/1308154/create-extension-vector-error-type-does-not-exist

Please take a look and let us know if this helped. If not, do reply so that we can further investigate.

Thanks
SSingh-MSFT 16,461 Reputation points Moderator

2023-07-10T09:11:51.4466667+00:00

Hi
Javier Outón •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Javier Outón 55 Reputation points

2023-07-10T09:16:42.9333333+00:00

Hi ShaktiSingh, thank you for your answer. Your are linking to flexible server but my scenario is cosmos-db. In cosmos DB (I think) we don't have server parameters. But as stated here https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/product-updates pgvector is availble since May 2023 for version 15 .
Javier Outón 55 Reputation points

2023-07-10T09:26:48.2933333+00:00

One more thing. When I query the extension named 'vector' I can see vector extension.

citus=> SELECT * FROM pg_available_extensions where name = 'vector'; name | default_version | installed_version | comment --------+-----------------+-------------------+-------------------------------------------- vector | 0.4.1 | | vector data type and ivfflat access method (1 row)
SSingh-MSFT 16,461 Reputation points Moderator

2023-07-13T04:01:04.2733333+00:00

Hi
Javier Outón •,

Thanks for the reply.

Let me check and get back to you.

Answer 1

SSingh-MSFT 16,461 Moderator

Hi
Javier Outón •,

Thanks for your patience.

I have tried to replicate the scenario by creating Azure Cosmos DB PostgreSQL by enabling Vector extension.

User's image

Kindly use command: SELECT CREATE_EXTENSION('vector');

OR

CREATE EXTENSION vector;

Result if shows like above that vector already exists, means it is enabled.

Refer: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/reference-extensions#pgvector-extension

https://github.com/pgvector/pgvector#installation-notes

Please try and let us know the result. If you face any issue, do reply so that we can further investigate.

If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thank you.

Javier Outón 55 Reputation points

2023-07-13T09:20:00.85+00:00

Hi, thank you very much for your response. Unfortunately the problem persists. These are the commands we had already tried and still don't work:
Javier Outón 55 Reputation points

2023-07-27T13:28:04.9133333+00:00

Hi ShaktiSingh-MSFT, sorry I missed your answer. The link you provide is not for super user but to be able to create new roles. In Cosmos DB super user is not possible (if not mistaken)
SSingh-MSFT 16,461 Reputation points Moderator

2023-07-28T04:07:48.3333333+00:00

Hi
Javier Outón •,

I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks
Javier Outón 55 Reputation points

2023-07-28T07:41:32.0933333+00:00

Hi ShaktiSingh, no we don't have any support plan. Thank you
SSingh-MSFT 16,461 Reputation points Moderator

2023-07-31T04:51:24.7+00:00

Hi
Javier Outón •,

Could you send an email to AzCommunity@Microsoft.com with your Subscription ID and thread link to this post, and I will enable a one-time free support request for your subscription.

Please reference this forum thread in the subject: ATTN: SHAKTI - How to enable vector extension in azure cosmos db

Regards,

@SSingh-MSFT

AzCommunity@microsoft.com

Answer 2

SSingh-MSFT 16,461 Moderator

Hi
Javier Outón •,

Thanks for the reply with screenshot.

This looks like permission issue which is not allowing to create extension.

If the extension is not already enabled, you may try using superuser.

Use link https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/howto-create-users to create user and try again.

Let us know how it went and if you could perform or get stuck. We will look into this further.

Thank you.

Share via

How to enable vector extension in azure cosmos db

2 answers

Your answer