pgvector extension in postgres flexible server is not working

Kaja Kandare 5 Reputation points

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 images below).

User's image

User's image

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.

User's image

Could you please assist me in finding a solution?

Thank you.

Azure Database for PostgreSQL
{count} vote

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 11,376 Reputation points Microsoft Employee

    Kaja Kandare

    This could be an intermittent issue, could you please try to re-login and see if that solve the problem?

    Also, you can also check if the shared_preload_libraries configuration parameter includes the "vector" extension. You can check this by running the following query:

    SHOW shared_preload_libraries

    If the "vector" extension is not included in the list, you can add it by modifying the postgresql.conf file and restarting the PostgreSQL server.

    I hope this helps. Let me know if you have any further questions.



    0 comments No comments

  2. Newton, Tim 0 Reputation points

    See the following for information on how I got this working in Azure :-

    In summary I had to upgrade to version 15 (preview) of PostgreSQL and select the extension called Vector under the azure.extensions server parameter but the above gist explains this in more detail.

    0 comments No comments