Re: 7.3 : how add user when last user have lost 'createuser' option - Mailing list pgsql-sql

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> alban wrote:
>> i have execute
>> ALTER USER postgres WITH NOCREATEUSER;

> Uh, you removed createuser permission from the postgres super-user.

That was a really bad move :-(

If you have no superusers left, I think your only option is to shut down
the postmaster, start a standalone backend, and ALTER USER postgres back
to superuser status in the standalone backend.  Then you can restart the
postmaster.

IIRC this will work in 7.3 and probably 7.2.  If you're running
something older, you are well and truly hosed, because you can't
reclaim superuser status even with a standalone backend.
        regards, tom lane