Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

Поиск
Список
Период
Сортировка
Искать
От
Bryn Llewellyn
Тема
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?
Дата
Msg-id
487898A1-46F5-4351-9BEA-D7170BDBC9D5@yugabyte.com
Ответ на
Список
Дерево обсуждения
Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn <bryn@yugabyte.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn <bryn@yugabyte.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Ron <ronljohnsonjr@gmail.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn <bryn@yugabyte.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Mladen Gogala <gogala.mladen@gmail.com>
adrian.klaver@aklaver.com wrote:

bryn@yugabyte.com:

Consider this wording. It also uses “good practice”.
«
It is good practice to limit the number of superuser roles that exist in a cluster to exactly one: the inevitable bootstrap superuser. This recognizes the fact that, once the initial configuration of a cluster has been done immediately after its creation (which configuration is done while still in self-imposed single-user mode), there are then very few, and infrequent, tasks that require the power of the superuser role.
»

No
body supports it!

I went back through the thread and don't anywhere when you made the above statement, correct me if I am wrong. In that case there was nothing to support or not support until now. What people where responding to the title of the thread:

"Seeking practice recommendation: is there ever a use case to have two or more superusers?"

That is a different ask.

I didn't mean to say that I'd already written the sentence that starts "It is good practice to limit the number of superuser roles that exist in a cluster...". Sorry if I gave that impression. It was just a strawman version of what I practice recommendation might look like that used the same general wording style as the one about "a role that has the CREATEDB and CREATEROLE".






В списке pgsql-general по дате отправления
От: David G. Johnston
Дата:
От: Adrian Klaver
Дата:
FAQ