ERROR: must be superuser to alter superusers

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: must be superuser to alter superusers
Date: 2007-09-24 12:20:52
Message-ID: 6C0CF58A187DA5479245E0830AF84F4218CF2B@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Brain 2007-09-24 12:21:25 pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
Previous Message Anoo Sivadasan Pillai 2007-09-24 11:34:09 Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?