CODEWITHSUNDEEP
postgresqlazure
Jeb50
Jeb50

Reputation: 7067

Azure pg ERROR: must be superuser to create superusers

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?

Upvotes: 0

Views: 1411

Answers (1)

Anand Sowmithiran
Anand Sowmithiran

Reputation: 2920

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

Upvotes: 1

Related Questions