Re: user connection not recorded? - Mailing list pgsql-general

From Tom Lane
Subject Re: user connection not recorded?
Date
Msg-id 20486.1438267574@sss.pgh.pa.us
Whole thread Raw
In response to Re: user connection not recorded?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: user connection not recorded?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> Eventually got around to figuring that. So just for my reference, the
> code snippet I showed from postinit.c seems to show a path where a
> username is not used but is  substituted with BOOTSTRAP_SUPERUSERID.

That's single-user mode.

> Am I following that correctly and what is BOOTSTRAP_SUPERUSERID?

BOOTSTRAP_SUPERUSERID is the OID of the precreated superuser.

The reason for that hack is to ensure you can still log in, in single-user
mode, even if you've done something stupid like "delete from pg_authid".
You'll be running under a user OID that doesn't actually exist in
pg_authid, but it won't matter because the code will believe you're a
superuser and will never go looking for the missing row.  Then you
can create yourself a new superuser, and resolve not to do that again.

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: user connection not recorded?
Next
From: Adrian Klaver
Date:
Subject: Re: user connection not recorded?