CREATE SUPERUSER in PaaS offering of Azure Database for Postgres

Question

Hi,

i logged into the azure Postgres database , with the admin user credentials , that i gave at the time of creating the Azure Database for Postgres

Now when i try to create SUPERUSER , by giving the command
CREATE USER TESTER SUPERUSER; ---> it gives me error saying
must be superuser to create superusers

I was thinking , the ADMIN USER that i created for Azure Database for Postgres is itself the SUPER USER. Can we not create SUPER USERS in Azure Database for PostgreSQL

Please help

Answer 1

I figured out the answer myself.

In Azure Postgres , we cannot CREATE SUPERUSERS . Since this is a Managed Service , Only Microsoft is part of SUPERUSERS Group
Details in link here

The Azure Database for PostgreSQL server is created with the 3 default roles defined. You can see these roles by running the command: SELECT rolname FROM pg_roles;

azure_pg_admin
azure_superuser
your server admin user
Your server admin user is a member of the azure_pg_admin role. However, the server admin account is not part of the azure_superuser role. Since this service is a managed PaaS service, only Microsoft is part of the super user role.

Answer 2

When we postgres as service then we cannot be superuser but can enable extensions allowed

Azure console => Azure Database for PostgreSQL flexible server => <Database> => Server parameters => azure.extensions => <Select extensions> => Save