From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Bryn Llewellyn <bryn@yugabyte.com>
To: david.g.johnston@gmail.com
Cc: pgsql-general list <pgsql-general@lists.postgresql.org>
Subject: Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?
Date: Mon, 21 Nov 2022 10:34:17 -0800
Message-ID: <d51cebb0-d12a-7238-bad8-d31bdc60e84e@aklaver.com> (raw)
In-Reply-To: <9B82247D-3F56-47C1-A918-18E2E8DEDFAB@yugabyte.com>
References: <290EF7B8-D150-4AE1-8FFE-A38912CD1A8B@yugabyte.com>
<20221118200835.sgva7b6wgg4w7py7@hjp.at>
<0B653B38-2D7D-45D6-B87F-DD07200EA676@yugabyte.com>
<20221118221305.ku2ibj2bowahzn2y@hjp.at>
<11d24370-18c6-f736-85db-e9ae1814bb64@gmail.com>
<20221119085225.uivmxue2gef5utv2@hjp.at>
<40623F5C-5B99-4AFD-9AA6-ABFFE6B17606@yugabyte.com>
<6f5bb172-eea8-3456-60ab-0dd332b89d56@aklaver.com>
<Y3tQE9zy4IZU5KEZ@hermes.hilbert.loc>
<4380c01d-a182-8c13-f4e2-278ba8a3cf01@aklaver.com>
<9B82247D-3F56-47C1-A918-18E2E8DEDFAB@yugabyte.com>
On 11/21/22 9:40 AM, Bryn Llewellyn wrote:
>> adrian.klaver@aklaver.com wrote:
> Then there’s this (from the doc):
>
>> It is good practice to create a role that has the CREATEDB and CREATEROLE privileges, but is not a superuser, and then use this role for all routine management of databases and roles. This approach avoids the dangers of operating as a superuser for tasks that do not really require it.
>
>
> That, too, reads like a recommendation that intends to inform a security policy. But, I suppose, one could argue that saying something “is good practice” is very different from making a recommendation.
>
> 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’m puzzled why the good practice statement about a role with the CREATEDB and CREATEROLE attributes earns a place in the doc while nobody at all is prepared to make a practice statement about how many superusers is good. I’d like very much to understand the critical parts that I’m missing of the essential mental model in this general space.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, bryn@yugabyte.com, david.g.johnston@gmail.com
Subject: Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?
In-Reply-To: <d51cebb0-d12a-7238-bad8-d31bdc60e84e@aklaver.com>
References: <290EF7B8-D150-4AE1-8FFE-A38912CD1A8B@yugabyte.com> <20221118200835.sgva7b6wgg4w7py7@hjp.at> <0B653B38-2D7D-45D6-B87F-DD07200EA676@yugabyte.com> <20221118221305.ku2ibj2bowahzn2y@hjp.at> <11d24370-18c6-f736-85db-e9ae1814bb64@gmail.com> <20221119085225.uivmxue2gef5utv2@hjp.at> <40623F5C-5B99-4AFD-9AA6-ABFFE6B17606@yugabyte.com> <6f5bb172-eea8-3456-60ab-0dd332b89d56@aklaver.com> <Y3tQE9zy4IZU5KEZ@hermes.hilbert.loc> <4380c01d-a182-8c13-f4e2-278ba8a3cf01@aklaver.com> <9B82247D-3F56-47C1-A918-18E2E8DEDFAB@yugabyte.com> <d51cebb0-d12a-7238-bad8-d31bdc60e84e@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox