Home > database >  Azure pg ERROR: must be superuser to create superusers
Azure pg ERROR: must be superuser to create superusers

Time:12-06

pgAdmin 4 connected to Azure already as a "Server admin login name", attempt to replicate my working pg DB at Azure, when applying this generated script received:

"ERROR: must be superuser to create superusers"

-- Role: postgres
-- DROP ROLE postgres;

CREATE ROLE postgres WITH
  LOGIN
  SUPERUSER
  INHERIT
  CREATEDB
  CREATEROLE
  REPLICATION
  ENCRYPTED PASSWORD 'md5x1...';

How to make myself a superuser?

CodePudding user response:

You cannot create superuser, as we are given only an admin user when we create the PG server resource. See official document.

  • Related