Re: System username in pg_stat_activity

Hi,

On Wed, Jan 10, 2024 at 02:59:42PM +0100, Magnus Hagander wrote:
> On Wed, Jan 10, 2024 at 2:56 PM Bertrand Drouvot
> I definitely think it should be the same. If it's not exactly the
> same, then it should be *two* columns, one with auth method and one
> with the name.
>
> And thinking more about it maybe that's cleaner, because that makes it
> easier to do things like filter based on auth method?

Yeah, that's sounds even better.

>
> > > + <row>
> > > + <entry role="catalog_table_entry"><para role="column_definition">
> > > + <structfield>authname</structfield> <type>name</type>
> > > + </para>
> > > + <para>
> > > + The authentication method and identity (if any) that the user
> > > + used to log in. It contains the same value as
> > > + <xref linkend="system-user" /> returns in the backend.
> > > + </para></entry>
> > > + </row>
> >
> > I'm fine with auth_method:identity.
> >
> > > + S.authname,
> >
> > What about using system_user as the field name? (because if we keep
> > auth_method:identity it's not really the authname anyway).
>
> I was worried system_user or sysuser would both be confusing with the
> fact that we have usesysid -- which would reference a *different*
> sys...

If we go the 2 fields way, then what about auth_identity and auth_method then?

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com