From: Bruce Momjian <bruce@momjian.us>
To: maja zaloznik <maja.zaloznik@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Seeming contradiction in 22.1
Date: Wed, 27 Sep 2023 18:11:44 -0400
Message-ID: <ZRSooHXRdtyi9gO0@momjian.us> (raw)
In-Reply-To: <CABYHV=VestugS_XWi=Uc7EzygPc1LFYQX=acj_BkxUH_MUDLxA@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>
<1821386.1679584161@sss.pgh.pa.us>
<CABYHV=VestugS_XWi=Uc7EzygPc1LFYQX=acj_BkxUH_MUDLxA@mail.gmail.com>
On Thu, Mar 23, 2023 at 05:45:03PM +0100, maja zaloznik wrote:
> Thanks David, this is very helpful!
>
> I would have to agree with Tom, that while technically true, the text could be
> reworded. namely it was not obvious to me that i had used a 'packager' to
> install the clusters and therefore was doing something outside the purview of
> the postgres documentation.
>
> To me the last sentence would be clearer if it read something like:
>
> "Most packagers will name this role `postgres` by default, but this is not
> required".
>
> That way it avoids the passive tense which leaves some ambiguity as to who or
> what and when is naming this superuser.
I think the paragraph was trying to do too much so I simplified it,
patch attached.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
Attachments:
[text/x-diff] bootstrap.diff (1.4K, ../ZRSooHXRdtyi9gO0@momjian.us/2-bootstrap.diff)
download | inline diff:diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgmlnew file mode 100644index 27c1f3d..92a299d
*** a/doc/src/sgml/user-manag.sgml
--- b/doc/src/sgml/user-manag.sgml
*************** SELECT rolname FROM pg_roles WHERE rolca
*** 103,113 ****
<para>
In order to bootstrap the database system, a freshly initialized
system always contains one predefined login-capable role. This role
! is always a <quote>superuser</quote>, 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 <command>initdb</command>.
! It is common, but not required, to arrange for this role to be named
<literal>postgres</literal>. In order to create more roles you
first have to connect as this initial role.
</para>
--- 103,112 ----
<para>
In order to bootstrap the database system, a freshly initialized
system always contains one predefined login-capable role. This role
! is always a <quote>superuser</quote>, and it will have
the same name as the operating system user that initialized the
! database cluster with <command>initdb</command> unless a different name
! is specified. This role is often named
<literal>postgres</literal>. In order to create more roles you
first have to connect as this initial role.
</para>
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: bruce@momjian.us, maja.zaloznik@gmail.com, tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Seeming contradiction in 22.1
In-Reply-To: <ZRSooHXRdtyi9gO0@momjian.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