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.