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.