Subject: Updating Extension Versions Without Superuser Privileges in Azure Database for PostgreSQL - Flexible Server

Question

Hello,

I am working with Azure Database for PostgreSQL - Flexible Server and am trying to update the vector extension from version 0.4.1 to 0.5.1. However, I've encountered a couple of issues due to the lack of superuser privileges, which are not available on the Flexible Server environment. The command ALTER EXTENSION vector UPDATE TO '0.5.1'; is not executable without superuser rights, and since the extension already exists, the DROP EXTENSION vector; command is also not an option.

Additionally, my current database version is 15.4, and while I attempted to upgrade to version 16, it appears not to be generally available yet.

Is there an alternative method to update the extension or change its ownership without superuser access? Any suggestions for workarounds or solutions that comply with the Flexible Server's limitations would be greatly appreciated.

Thank you.

Answer 1

Hi
JipyeongChoi-2795,

Welcome to Microsoft Q&A forum.

As I understand, you want to Update Extension Versions Without Superuser Privileges in Azure Database for PostgreSQL - Flexible Server.

Here is the complete documentation on How to enable and use pgvector on Azure Database for PostgreSQL - Flexible Server:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pgvector

I am checking internally if there is any workaround without superuser, thanks.

Answer 2

Hi
JipyeongChoi-2795,

I have checked internally and got the below reply.

For upgrade to PG 16 from 15 you are right it isn’t available as yet – I believe time frame is Q1 CY2024.

If there is urgency on this, please raise support case 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.

Once case is raised, please share with us the case number.

Thanks