Обсуждение: ERROR: must be superuser to alter superusers

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

On 9/24/07, Philippe Lang <philippe.lang@attiksystem.ch> wrote:
> 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:

That's kind of the equivalent of locking your keys in the car...

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

You have two choices.

1: re-initdb your database, losing everything
2: start your db in single user mode.

to start your db in single user mode, you need to su - to the postgres
superuser, then issue the command postgres --single.  From there you
can then set a user back to being a superuser.