"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> And while we're at it, maybe we should have a setting somewhere should
> someone execute the famous "update pg_shadow set usesuper = false" that
> someone did a while back to be able to force an account to be a superuser
> account.
We already have an adequate solution for that one: shut down the
postmaster and run a standalone backend. You are always superuser in
a standalone backend, so you can create a new superuser or just reverse
the UPDATE command.
regards, tom lane