Re: ERROR: must be superuser to alter superusers

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.