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

From maja zaloznik
Subject Re: Seeming contradiction in 22.1
Date
Msg-id CABYHV=UTy=_WSnSvMPon-Y5TJhoy2jf10=xeNEGT5NzfjR3zaA@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 David,

sorry for pushing this - I don't mean to imply what you say is not true, but would like to understand how it can be true and at the same time users like me are convinced otherwise. The internet is chock full of instructions and tutorials mentioning the default superuser is postgres, not the user's os username as far as i can tell (except for official pg documentation). Another example is the user Tim in this thread https://stackoverflow.com/questions/50883645/is-postgres-a-default-and-special-user-of-postgresql, who also seems to be convinced that they didn't name the superuser postgres.

I'm tempted to do another install on my laptop to see what happens :))

My point being that if what you say is true but runs counter to what essentially all other instructions on the internet say, it would seem prudent to mention this disparity and the reasons for it in the canonical documentation, which would be especially valuable for noobs like me.

Thanks again for your help,
Maja






On Thu, 23 Mar 2023, 00:42 David G. Johnston, <david.g.johnston@gmail.com> wrote:
On Wed, Mar 22, 2023 at 3:41 PM maja zaloznik <maja.zaloznik@gmail.com> wrote:
My issue is that - at least as far as i can recall - the default superuser was already named postgres
 
There is no compiled-in default for the name of the bootstrap superuser.  It is chosen during initdb using the algorithm described (i.e., o/s user running initdb or the name specified on the CLI)

David J.

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Publishing Postgres Manual as a book
Next
From: "David G. Johnston"
Date:
Subject: Seeming contradiction in 22.1