From: | maja zaloznik <maja(dot)zaloznik(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Seeming contradiction in 22.1 |
Date: | 2023-03-22 22:41:04 |
Message-ID: | CABYHV=W5TKoLMD3Wjrq2foKGSYpf5sQ-HifvdPSxUNY+4NFwcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Monday, March 20, 2023, PG Doc comments form <noreply(at)postgresql(dot)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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-03-22 23:42:15 | Re: Seeming contradiction in 22.1 |
Previous Message | David G. Johnston | 2023-03-22 21:48:06 | Re: Seeming contradiction in 22.1 |