Re: Seeming contradiction in 22.1 - Mailing list pgsql-docs

From maja zaloznik
Subject Re: Seeming contradiction in 22.1
Date
Msg-id CABYHV=W5TKoLMD3Wjrq2foKGSYpf5sQ-HifvdPSxUNY+4NFwcg@mail.gmail.com
Whole thread Raw
In response to Re: Seeming contradiction in 22.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Thanks for your reply David,

i think you are right about the natural way to interpret the text - although if that was the intention it could probably be worded more clearly e.g. by adding 'renamed' or 'instead' or both.

My issue is that - at least as far as i can recall - the default superuser was already named postgres, in which case that interpretation doesn't work. I apologize if I'm mistaken, I've only setup a cluster twice and an not 100% on this.

Also, i forgot to mention the first time : kudos to everyone for the insanely good documentation, it really is outstanding!

Best,
Maja 


On Wed, 22 Mar 2023, 22:48 David G. Johnston, <david.g.johnston@gmail.com> wrote:
On Monday, March 20, 2023, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/database-roles.html
Description:

In chapter 22.1 the following text seems to imply the role will have "the
same name as the user that initialised" it and also the "role will be named
postgres". Which cannot both be true, or perhaps the text is trying to say
something else, but in doing so is not clear.

"This role is always a “superuser”, and by default (unless altered when
running initdb) it will have the same name as the operating system user that
initialized the database cluster. Customarily, this role will be named
postgres. "

The words “default” and “unless altered” seem quite clear to me.  In particular, the “customarily” part is accomplished usually by creating an operating system user named postgres and then running initdb as that user.

David J.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Seeming contradiction in 22.1
Next
From: "David G. Johnston"
Date:
Subject: Re: Seeming contradiction in 22.1