Hi Cuong Tran,
As per the MS documentation, here are the details -
After an extension is allowlisted and, if the extension requires it, is also added to shared_load_libraries
, it can be created or installed in each database on which it's to be used.
- To create an extension, a user must be a member of the
azure_pg_admin
role. - Run the CREATE EXTENSION command to create or install a particular extension. This command loads the packaged objects into your database.
As per above details, it is confirmed that user must be a member of the azure_pg_admin role. I can see the document is updated two weeks back hence there is a possibility that this change is introduced two weeks back.
Reference Document - https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions?tabs=allow-extensions-portal%2Cload-libraries-portal
Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.