Azure Postgres Flexible server: Unable to add azure_storage extension

Peter Koller 40 Reputation points
2024-04-10T15:10:44.06+00:00

We are unable to add a the azure_storage extension to a second database. We got it to work on the default postgres database but when trying to add it to a second database with 

CREATE EXTENSION azure_storage;

We get

role "azure_storage_admin" cannot be dropped because some objects depend on it

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-04-10T20:44:48.5366667+00:00

    Hi, @Peter Koller Thanks for posting your question in the Microsoft Q&A forum.

    I understand that you are trying in Postgres 16 version. are you dropping or creating the extensions? the error message you got is dropping so I am confused? you have to remove dependencies before dropping extensions. and if you want to add I hope you have added extensions under server parameter if not please check below steps.

    User's image

    I tried to add on my second database and was successfully added.

    User's image

    Regards

    Geetha

    0 comments