On Thu, Apr 7, 2011 at 11:15 PM, Grzegorz Szpetkowski
<gszpetkowski(at)gmail(dot)com> wrote:
> Is there any way to restore superuser without recreating cluster from
> scratch (initdb, pg_createcluster etc.) ? Or better should PostgreSQL
> prevent for such situation (mistake command) ? I don't know is there
> any "at least one superuser per cluster rule" (?)
I think you should be able to start Postgres in single-user mode, see:
<http://www.postgresql.org/docs/9.0/static/app-postgres.html>
and from there you can fix your superuser privileges.
Josh