Search code examples
databasepostgresqlazurepsql

Postgres - I don't have a superuser and I can't create a role or I can't grant access to any other user as a superuser

I'm currently working through postgres migration, and for some reason the database doesn't allow me to login as the superuser. I also tried to reset the password from the superuser user and I can't.

The services are running through Azure, and the type of server is called Postgres SQL flexible server.

Commands that I have ran already:

ALTER ROLE [USER] WITH SUPERUSER;
ALTER ROLE [USER] WITH PASSWORD '[NEW-PASSWORD]'

The type of error that I'm getting is the following:

Error: Must be superuser to create superuser

What could be the best way to solve this situation? Does anyone knows how to force the creation of a superuser?

Solution

  • The admin user is the highest privilege user you have on the server. It belongs to the role azure_pg_admin. This role does not have full superuser permissions. The PostgreSQL superuser attribute is assigned to the azure_superuser, which belongs to the managed service. You do not have access to this role. You can read more here.