Date: Tue, 10 Sep 2024 18:50:35 -0700 (PDT)
From: Chris Miller <cjm@tryx.org>
Reply-To: Chris Miller <cjm@tryx.org>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Message-ID: <413962829.8625.1726019435545.JavaMail.zimbra@tryx.org>
In-Reply-To: <CAKFQuwbpdwCxDgY5cjDh-8uneNA010BLfd8TEGF5BJOksxRtbg@mail.gmail.com>
References: <172601029329.1028.17318986799853058856@malur.postgresql.org> <1738731565.8400.1726010470879.JavaMail.zimbra@tryx.org> <CAKFQuwbpdwCxDgY5cjDh-8uneNA010BLfd8TEGF5BJOksxRtbg@mail.gmail.com>
Subject: Re: Test mail for pgsql-general
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="=_f826e92d-a962-4449-a1ee-fa4b0f6b3b6a"
Thread-Topic: Test mail for pgsql-general
Thread-Index: eMfcemiBXKgw3KHhs0DxAqBWDCcXKA==
Archived-At: <https://www.postgresql.org/message-id/413962829.8625.1726019435545.JavaMail.zimbra%40tryx.org>
Precedence: bulk

--=_f826e92d-a962-4449-a1ee-fa4b0f6b3b6a
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Hi David, 

> The second line is pointless, the first three columns are compared against the
> incoming connection host/user/dbname to find out how authentication should be
> handled. The first match wins. So for every local connection peer, and only
> peer, is going to be used since everything matches all/all.

> There is no way to give a user a choice of how to authenticate. There will be
> one accepted option for a given set of connection values.

This answers my question. Thanks for the help, 
-- 
Chris. 

--=_f826e92d-a962-4449-a1ee-fa4b0f6b3b6a
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"font-family: arial, helvetica, sans-serif; font-s=
ize: 12pt; color: #000000"><div>Hi David,<br></div><div data-marker=3D"__QU=
OTED_TEXT__"><blockquote style=3D"border-left:2px solid #1010FF;margin-left=
:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-=
decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><di=
v>The second line is pointless, the first three columns are compared agains=
t the incoming connection host/user/dbname to find out how authentication s=
hould be handled.&nbsp; The first match wins.&nbsp; So for every local conn=
ection peer, and only peer, is going to be used since everything matches al=
l/all.</div><br><div>There is no way to give a user a choice of how to auth=
enticate.&nbsp; There will be one accepted option for a given set of connec=
tion values.</div></blockquote></div><div><div>This answers my question. Th=
anks for the help,<br></div><div>--<br></div><div>Chris.</div></div></div><=
/body></html>
--=_f826e92d-a962-4449-a1ee-fa4b0f6b3b6a--