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

From: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?
Date: 2022-11-21 19:46:11
Message-ID: 487898A1-46F5-4351-9BEA-D7170BDBC9D5@yugabyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> adrian(dot)klaver(at)aklaver(dot)com wrote:
>
>> bryn(at)yugabyte(dot)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.
>> »
>>
>> Nobody 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".

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-11-21 21:36:33 Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?
Previous Message David G. Johnston 2022-11-21 19:26:10 Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?