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

From Bryn Llewellyn
Subject Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all
Date
Msg-id 7DE7B1E4-5D44-4F93-845B-B542853AE3C3@yugabyte.com
Whole thread Raw
In response to 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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> tgl@sss.pgh.pa.us> wrote:
>
>> david.g.johnston@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 established by now --- I count half a dozen uses in
ourSGML docs and another dozen or so in the code --- and it's certainly more specific than "database superuser". We
shouldprobably create a glossary entry for it and then change all the uses of "database superuser" as appropriate. 
>
> However ... it looks to me like some of those uses just mean to distinguish between Postgres-specific superuser-dom
asopposed to whatever the term might mean out in the operating system. But I'm not sure that anybody really uses that
termfor an OS-level 
> concept on any popular OS, so it feels a bit pedantic as well as confusing.  Should we leave those usages alone, or
reducethem to just "superuser"? 

Thanks, Tom. I'd certainly appreciate an entry in "Appendix M. Glossary" for the term of art that I've been struggling
toname. Until I hear what the experts decide, I'll use "catalog-owning role". Then I'll switch to the newly blessed
term.

I'm afraid that I didn't get your point in your last paragraph. The terms "within-cluster role" and "O/S user" seem to
capturethe distinction when the context doesn't make it clear. I aim never to use the term "user" for the
within-clusterphenomenon. After all, an existing within-cluster role can flip between "with nologin" and "with login"
atthe drop of a hat of the guy "with createrole". 


pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all
Next
From: Adrian Klaver
Date:
Subject: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all