Re: A fixed user id for the postgres user? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: A fixed user id for the postgres user?
Date
Msg-id Pine.LNX.4.30.0109072158120.680-100000@peter.localdomain
Whole thread Raw
In response to Re: A fixed user id for the postgres user?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> I've been thinking a little bit about how one might recover from Really
> Stupid Mistakes, like deleting one's only superuser pg_shadow entry.

> What I'm thinking is that if we hard-wired usesysid = 1 for the
> superuser, it'd be possible to arrange for standalone backends to fire
> up with that sysid and superuserness assumed, and not consult pg_shadow
> at all.  Then you'd have a platform in which you could do CREATE USER.

FYI:  I'm working on this now.  It seems to work out nicely; at least I
was able to recover from DELETE FROM pg_shadow; without a problem.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Escaping strings for inclusion into SQL queries
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: CVS access