pgvector extension in postgres flexible server is not working

Question

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 images 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

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.

Regards,

Oury

Answer 2

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

https://gist.github.com/sageTimNewton/f20583ff1f0cf0af648bc0a0a91c0083

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.