From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: maja zaloznik <maja.zaloznik@gmail.com>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Seeming contradiction in 22.1
Date: Thu, 23 Mar 2023 11:09:21 -0400
Message-ID: <1821386.1679584161@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwYdUpjOSUTymjHU9Hp-x50EJKWcQwVtBR4uaJ1TL3sF2Q@mail.gmail.com>
References: <167931662853.3349090.18217722739345182859@wrigleys.postgresql.org>
<CAKFQuwbH24u4aZMLpAm93p0kvZ+e8CqjKY-piYW5LyAEfRbXow@mail.gmail.com>
<CABYHV=W5TKoLMD3Wjrq2foKGSYpf5sQ-HifvdPSxUNY+4NFwcg@mail.gmail.com>
<CAKFQuwZuNhkxUsFF2BraLiQ3RHehhaNU1Y-1Fvqt8YX=PyHM=w@mail.gmail.com>
<CABYHV=UTy=_WSnSvMPon-Y5TJhoy2jf10=xeNEGT5NzfjR3zaA@mail.gmail.com>
<CAKFQuwYdUpjOSUTymjHU9Hp-x50EJKWcQwVtBR4uaJ1TL3sF2Q@mail.gmail.com>
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> The root issue, IMO, is that all packagers have settled on the convention
> of using Postgres for the superuser name, so if one only ever sees that, it
> is easy to assume it is some kind of default of the software itself. In
> the face of consistent evidence, people not reading the documentation is my
> supposed assumption for their ignorance of this point. But reading the
> docs, it is clear how the system really works (I.e., the name of the
> bootstrap superuser comes is derived at initdb time from the environment
> executing initdb).
I agree that the docs are not incorrect as they stand, but maybe they
could be phrased a little more clearly. The "Customarily," bit is perhaps
too terse. I'm thinking about wording like
This role is always a “superuser”, and by default it will have the
same name as the operating system user that initialized the database
cluster, unless another name is specified while running initdb.
It is common, but not required, to arrange for this role to be named
postgres.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, maja.zaloznik@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Seeming contradiction in 22.1
In-Reply-To: <1821386.1679584161@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox