"scott.marlowe" <scott.marlowe@ihs.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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
