Re: PG vs MySQL

"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