Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Tue, Nov 29, 2022 at 12:01:01PM -0500, Tom Lane wrote: > Yeah, I don't see that "cluster" adds anything. It's sometimes worth > saying "database superuser" to ensure that you don't confuse people > who might think of some external-to-Postgres meaning of "superuser", > but otherwise plain

Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

"David G. Johnston" writes: > On Tue, Nov 29, 2022 at 9:31 AM Bruce Momjian wrote: >> I know I am replying late here, but isn't it the database _cluster_ >> superuser? > The "cluster" being implied doesn't seem like a big deal. The shorter term > is nice. It doesn't seem worth changing all

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Tue, Nov 29, 2022 at 9:31 AM Bruce Momjian wrote: > > I know I am replying late here, but isn't it the database _cluster_ > superuser? > > The "cluster" being implied doesn't seem like a big deal. The shorter term is nice. It doesn't seem worth changing all the many, many, places in the

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Wed, Oct 26, 2022 at 09:57:50PM -0700, Adrian Klaver wrote: > On 10/26/22 18:33, Bryn Llewellyn wrote: > > The descriptive designation "the role that owns the SQL part of the > > implementation of PostgreSQL" is too much of a mouthful for daily use. > >  And anyway, this notion captures only

Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Thu, Oct 27, 2022 at 4:02 PM Tom Lane wrote: > "David G. Johnston" writes: > > Yes, the description for --username probably should be modified to read: > > > "Selects the user name of the cluster's bootstrap superuser." > > Yeah, perhaps. The term "bootstrap superuser" is reasonably well >

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On 10/27/22 17:20, Bryn Llewellyn wrote: david.g.johns...@gmail.com wrote: b...@yugabyte.com  wrote: The fact that the "bootstrap superuser" term of art denotes a matching pair of two principals (an O/S user and a within-cluster 

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> t...@sss.pgh.pa.us> wrote: > >> david.g.johns...@gmail.com wrote: >> >> Yes, the description for --username probably should be modified to read: >> >> "Selects the user name of the cluster's bootstrap superuser." > > Yeah, perhaps. The term "bootstrap superuser" is reasonably well

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> david.g.johns...@gmail.com> wrote: > >> b...@yugabyte.com wrote: >> >> This invariant must hold if an "ordinary" within-cluster superuser is to >> qualify as the cluster's "bootstrap superuser": >> >> the name of the bootstrap superuser's within-cluster role >> >> AND >> >> the name of

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> « >> You can start a session without specifying the name of the cluster role as >> which to authorize, its password, and the name of the database to which to >> connect, ONLY when these things are true: >> >> 1. The

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> The fact that the "bootstrap superuser" term of art denotes a matching pair >> of two principals (an O/S user and a within-cluster role) > > No, it does not. It denotes only the PostgreSQL role. "service user" is >

Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

"David G. Johnston" writes: > Yes, the description for --username probably should be modified to read: > "Selects the user name of the cluster's bootstrap superuser." Yeah, perhaps. The term "bootstrap superuser" is reasonably well established by now --- I count half a dozen uses in our SGML

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Thu, Oct 27, 2022 at 12:09 PM Bryn Llewellyn wrote: > > This invariant must hold if an "ordinary" within-cluster superuser is to > qualify as the cluster's "bootstrap superuser": > > the name of the bootstrap superuser's within-cluster role > > > AND > > the name of the O/S user that owns

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Thu, Oct 27, 2022 at 3:24 PM Bryn Llewellyn wrote: > *«* > *You can start a session without specifying the name of the cluster role > as which to authorize, its password, and the name of the database to which > to connect, ONLY when these things are true:* > > > > *1. The within-cluster

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Thu, Oct 27, 2022 at 12:09 PM Bryn Llewellyn wrote: > [*] I see that, in my Ubuntu installation, critical programs like > "postgres" itself, "initdb", "pg_ctl", "pg_dump" and so on are owned by > "root". > And they exist in a "bin" directory so that any user on the system can actually

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> jer...@musicsmith.net wrote: > >> b...@yugabyte.com wrote: >> >> I can now characterize what I'd observed more clearly, thus: only a >> bootstrap super user (as defined above) can start a session without >> mentioning the name of the database to which to connect

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> > I can now characterize what I'd observed more clearly, thus: only a > bootstrap super user (as defined above) can start a session without > mentioning the name of the database to which to connect and the name of the > within-cluster role to connect as—and without supplying a password. And it >

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

> adrian.klaver@aklaver.comwrote: > >> b...@yugabyte.com wrote >> >> The descriptive designation "the role that owns the SQL part of the >> implementation of PostgreSQL" is too much of a mouthful for daily use. And >> anyway, this notion captures only part of the story that makes "postgres"

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

(David and Ian, I'm resending this because, I see that I managed to omit "pgsql-general@lists.postgresql.org " from the addressee list. So, of course, it didn't show up in the "pgsql-general" archive.) > barw...@gmail.com

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On 10/26/22 18:33, Bryn Llewellyn wrote: The descriptive designation "the role that owns the SQL part of the implementation of PostgreSQL" is too much of a mouthful for daily use.  And anyway, this notion captures only part of the story that makes "postgres" uniquely what it is—at least on

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

Can you stop sending me message idk why I need my email back thanks Sent from my iPhone > On Oct 26, 2022, at 7:11 PM, Ian Lawrence Barwick wrote: > > 2022年10月27日(木) 11:00 David G. Johnston : >> >>> On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: >>> >>> The descriptive designation

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022年10月27日(木) 11:00 David G. Johnston : > > On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: >> >> The descriptive designation "the role that owns the SQL part of the >> implementation of PostgreSQL" is too much of a mouthful for daily use. > > > Don't think it's documented but I like

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: > The descriptive designation "the role that owns the SQL part of the > implementation of PostgreSQL" is too much of a mouthful for daily use. > Don't think it's documented but I like "bootstrap user" which I've seen bandied about here a