Re: Seeming contradiction in 22.1

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Publishing Postgres Manual as a book
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Seeming contradiction in 22.1