Re: Seeming contradiction in 22.1

Поиск
Список
Период
Сортировка
От maja zaloznik
Тема Re: Seeming contradiction in 22.1
Дата
Msg-id CABYHV=W5TKoLMD3Wjrq2foKGSYpf5sQ-HifvdPSxUNY+4NFwcg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seeming contradiction in 22.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Seeming contradiction in 22.1
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Seeming contradiction in 22.1