ERROR: must be superuser to alter superusers

["Philippe Lang" <philippe.lang@xxxxxxxxxxxxxx>]

Hi,

I had the very bad idea of removing the "superuser" flag from the
"pgsql" role. Now each time I try to set it back, with:

ALTER ROLE pgsql
  SUPERUSER;

... I get:

ERROR: must be superuser to alter superusers
SQL state: 42501

Since there is no superuser in the database engine anymore, what option
do I have?


I tried:

CREATE ROLE pgsql2
  SUPERUSER;

... But I get:

ERROR: must be superuser to create superusers
SQL state: 42501


Thanks,

Philippe Lang

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend