Re: PG vs MySQL - Mailing list pgsql-general

From Tom Lane
Subject Re: PG vs MySQL
Date
Msg-id 8979.1080596206@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG vs MySQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: PG vs MySQL
List pgsql-general
"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

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: PG vs MySQL
Next
From: Jan Wieck
Date:
Subject: Re: PG vs MySQL