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.