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