Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should
Date: 2022-10-30 16:22:53
Message-ID: 1d2c7784-66c1-34a3-1fbb-c5f2012b4d83@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/30/22 09:16, Karsten Hilbert wrote:
> Am Sat, Oct 29, 2022 at 09:15:08PM -0700 schrieb Adrian Klaver:
>
>>> *# MAPNAME    SYSTEM-USERNAME   PG-USERNAME*
>>> *# -------    ---------------   -----------
>>>   bllewell   mary              mary
>>> *
>>>
>>>
>>> As has been said numerous times, it is utterly pointless to define a mapping like this
>>> - you get mary-is-mary for free just by saying peer.
>
> It certainly is but he probably did it just to check whether
> anything changes when another code path is run (the mapping)
> while the previously-working result (= successful login)
> should not change (mary is still mary). despite the
> additional code path.

Except the mapping was never in play as the map was not specified in
ph_hba.conf.

>
> It seems to be a way of bisecting in order to verify/falsify
> assumptions in his mental model.
>
> Karsten
> --
> GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-10-30 22:05:09 Re: Unix users and groups... Was: "peer" authentication...
Previous Message Karsten Hilbert 2022-10-30 16:16:47 Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should