Re: Big problem - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Big problem
Date
Msg-id 20040524141028.GA2595@dcc.uchile.cl
Whole thread Raw
In response to Big problem  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Mon, May 24, 2004 at 09:54:20PM +0800, Christopher Kings-Lynne wrote:

> in phpPgAdmin and managed to remove superuser privileges from his only 
> superuser.
> 
> We thought and though but it seems that there is no way to recover from 
> this situation except a re-init and reload.  And what user is he even 
> going to dump as?

Hmm ... I'm not sure but maybe with a standalone backend it can be
recovered?

If not, I'd suggest compiling a hacked backend with the permission check
for the ALTER USER ripped out, use that to correct the problem, and then
erase it (and the patch).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)



pgsql-hackers by date:

Previous
From: Ned Lilly
Date:
Subject: MySQL Lays Path for SAP Integration
Next
From: Tom Lane
Date:
Subject: Re: Big problem