From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>,
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Delays between "connection received" and "connection
 authenticated" because of localhost entries in hba
Thread-Topic: Delays between "connection received" and "connection
 authenticated" because of localhost entries in hba
Thread-Index: AQHbKh+aHf1bKlFziUSkLwj47Vg/rbKe1GUAgAAMi+0=
Date: Wed, 30 Oct 2024 07:10:15 +0000
Message-ID:
 <GV0P278MB04198D3BBE5F475C75D34C74D2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References:
 <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <376cac6e4ffe1dfb9f59f47a9652dfa49c033ec6.camel@cybertec.at>
In-Reply-To: <376cac6e4ffe1dfb9f59f47a9652dfa49c033ec6.camel@cybertec.at>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=dbi-services.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: GV0P278MB0419:EE_|ZR3P278MB1439:EE_
x-ms-office365-filtering-correlation-id: 9629d93e-ff5e-4763-7383-08dcf8b1e76a
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|38070700018;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?8ubkzq4wXXVSkA78TpOW65/hK8OOwqTt0hUHCMqxIfMOVL91tSepPwG8UV?=
 =?iso-8859-1?Q?H3lBkgprrFnHQkNTjncScAqTWxxGsW+Ipn68Dkw59pKoD1qyoXGrVtbD6q?=
 =?iso-8859-1?Q?PnmKDRiVMEstxIrYf5I8/Il22vr1NOXmFd36xQiJDhizlrm86E46GCgEWd?=
 =?iso-8859-1?Q?+uRygsik+7lcVeJhV2B9w8/V+n06JPkMhylYf/I0uMmlEFhflWetpOcyXP?=
 =?iso-8859-1?Q?oeOABW0lABbWOg+5wzmqTMEIaw/LkQFwO0TF84PCUplSiTg3kNetRMu9mA?=
 =?iso-8859-1?Q?rBlQQbajeC2ECGCtMNhJvc33IgCU9Y2vuqlR6wV8Pf9w+9lHQ1AlZlT+4j?=
 =?iso-8859-1?Q?3mXImtNXhtM3A2x0HIFDJMFX+IldjC1Sqv6/XwtJJahOAkU3dZvnYEemDw?=
 =?iso-8859-1?Q?4TMQM/FShwjsknQMoOcqrOpctP4Le5bxdHF07Mnn6NzXxB7q0wwCPEh9sv?=
 =?iso-8859-1?Q?6WeYz4pZOF7fOGfFtuBFuv/WNHyjLHdU+dEgjDnDz6aW+1zonMOKa6kXLv?=
 =?iso-8859-1?Q?0ui0XqfSEPMpf0+s4tbOMLkhghKmBef7A/P+My/tlhwmVhJWe6a2d+O+Lg?=
 =?iso-8859-1?Q?XhqZqODujw5dI69CTqazoBmot/wQBZFEYDBZLVtz4xICh/XYj0Xrsidc1x?=
 =?iso-8859-1?Q?psc175luci11ANq4Pbz197VF/GI3T2Y/vplB3WEhSkON3X9mDXPx4caB7z?=
 =?iso-8859-1?Q?vMTlXqtN5fyDjvPjTLKcmMkjiQ2XNFmCVFr7ChAoqevmg0vmeNIS4D2cu1?=
 =?iso-8859-1?Q?OObUYf3d4aOIz60fBwHTdczrLR7zjgMP4xCoSpQQ/wp9u3OlE3VyTfI8+o?=
 =?iso-8859-1?Q?iyxair//L7idwAfbhv9g6i/nI22tIXcOtclWN0JJcUU4bGTn4SEWeOFU1e?=
 =?iso-8859-1?Q?irZoN7ZNo/F45clT7Mfc9U8v4EFamSPwJYPwtY4OsRsI09VC2wHd0dXKbL?=
 =?iso-8859-1?Q?cK0ePouMaI6DY5wD5WSYwfnfy2jA2Do3gcKANp7KXJjhR0u0vN+U1Wv5gI?=
 =?iso-8859-1?Q?liZXt0tQvUfwTbCoknN19LIF1M4N0vLFnoZTwChLNs0L//9Ek4kLUwbW3A?=
 =?iso-8859-1?Q?/zyBEuCtbcX2MZOPWt21OWAuO223AxOIvmhd/8LM/ofFugEv9lvMOxs2kt?=
 =?iso-8859-1?Q?NW9x3stnK/L61uq02pAsvUjUHKCSPTUCTCzg08hXV9RluCIUj/GVuW5NHR?=
 =?iso-8859-1?Q?tJzNuQX6nkfD5zdWU1N292iFQnJrnZYANI9Y0A+HBUlYw/hQ9GHi7THApY?=
 =?iso-8859-1?Q?eBQvX4QdgnDnoGpY/ZikAbj8S2iXqUn0kkyq7dszv8imJGNs86JDJilGNS?=
 =?iso-8859-1?Q?4H4Wp1h7zIWDR1UQZ1+HvKyE/arm5L2HQt558LCSgusVhyJz8ukFiwph+s?=
 =?iso-8859-1?Q?rUdSNTZKKSx7B2q4MiQue8qWPOtzWXmjkQYQORZUBZoCzmkymULeU=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?QDFbVe3FNhQ4LrGhTNI4BlUDIc3tnmPuICGWXQ+kudbHDpWdZahTfRCMx7?=
 =?iso-8859-1?Q?7msozS6Qoqtk0FTmed6SNBnq9Ak3Hq1W9zm4iNxKc+S3mjZvBhEU4rfmTc?=
 =?iso-8859-1?Q?BmrOlJ2qP696/pURSpTWn9Ytdoe+wd2eQUb9178qM+k1r4XxR0sTsoZ+ro?=
 =?iso-8859-1?Q?smMAsN0Fn4HWSdGtOh+Ajym8b5/mx5GVtPfOss3gPZjMuTOrv4nUV39Av9?=
 =?iso-8859-1?Q?AN0LkHM6SQ/gtYOXdqVtiOdSDD57cyCMtcmrOWC5hbZ3q/48E/U3OfHNl0?=
 =?iso-8859-1?Q?VUznIcoJ8ym0nwB/29mBi3SjRay1V++CwVbF0PcLkH7j5AHkThjo8meImV?=
 =?iso-8859-1?Q?CUlpav+QJoGbWmewMi2OQYVhrthXU041rrmANfXug+IW+QOdV4pZXG2hfC?=
 =?iso-8859-1?Q?fmCEe2opgAptL21ApunnsH23iLT8VUMqPxX0EKaH/6354K17POPrhsNqp2?=
 =?iso-8859-1?Q?0h5wonlQ/MnOrgXvxZLEG/I7sy6iHkmudlkN0Bzs3Wc4BLi+Sps3P7+qR3?=
 =?iso-8859-1?Q?ZFju0fClYl9oh4+IIhM2RuBaz1q71os1RUOLTnUWltu0OYAXbn0vMnvV35?=
 =?iso-8859-1?Q?ilyvLBRx3OIkB2w4Y41NCvYkI03PXNMeOwVSEcVDSnnxvaUyuGHT/AjBRK?=
 =?iso-8859-1?Q?v+1cx+cjUkTv9QP/NYoB3eF+TKR5psP8nws0Ftm15tnRgt1q9gZy7mp2DM?=
 =?iso-8859-1?Q?3TFgMGP87zMF7FD5EhFyan5z62N0uKQklQKcWNPM6UgbyblA7qPxARbFEt?=
 =?iso-8859-1?Q?yagAhqb9OVv897+fFGwwEiPCgSX/tqsB79+xOY6Xdwe1uNNzw/DMr9cp3n?=
 =?iso-8859-1?Q?8ZMKiUe+QzrQiN1nPPxE9DteSPl+Q0tYWjWKcgE7Oa/XM8jBIaLwrQpN6q?=
 =?iso-8859-1?Q?2znGJ+WD0LVDCT391R1ixnFwrL/uo745zjLyT58SpwC60BQ96K6CyMJXV+?=
 =?iso-8859-1?Q?cKwKWKM51J9jKvPlqyzkimICBH7s1RODGYd1cfb9/5uOMpGjzUTLP+s7dK?=
 =?iso-8859-1?Q?l6ugaTiDnK4P5AXoe+8zFe2HPfVWsMYDW+DciGEeaXqXncwc8oig37Xt3a?=
 =?iso-8859-1?Q?a5+PJVqr6+OHF+sccM3mfv44KXBo+H9lWQle2pWt96m6o+VM3INYO93bOx?=
 =?iso-8859-1?Q?Rn6NOS2jsa3RGzTKLclXasQKTz+O3ZhJE5kwv0BWbw6Y4IgRiBbGiIf5mR?=
 =?iso-8859-1?Q?O979kpMOhvgIqH+3tZo3Dgnjcmt1nN/AfA0ajh8sxxb4rTxwF7u10jv9a3?=
 =?iso-8859-1?Q?2x0Kj8rxfrDQFNVEm2g9nBL78Xm/6FjQudM0O1mZTqEs0iTFW1ZZi1WAm+?=
 =?iso-8859-1?Q?kbMT3KRcj3jc9ICOHFh7mi2o5qq46bza4MuDsgmk9UwX1KG29LGrwpok8R?=
 =?iso-8859-1?Q?zzul9KahPb6D98N3fKo9BZdisvsiCdYIoCx8l+GfZqPce0Qs4CubV8N5lw?=
 =?iso-8859-1?Q?J2ok8cMM85R46aeDc8mTqW3R77e+javeVx1FTiBLFskXBZKn+8UwIFu5YG?=
 =?iso-8859-1?Q?5nxHwqdndhMpciJz5jIuDcs5cNwsR/ywx41+nVa9OdxAR2n3G93k9Trxdz?=
 =?iso-8859-1?Q?TfwlURkW5kEIvXIvjCJ/2IMpYIpopKtOVZ73v2jBoCv5ptn2PI8FT7DxxJ?=
 =?iso-8859-1?Q?CcD+3jc6nRwd8httnXKLo2293cHAtmw1PZUm9x/RsKSyNy0m3sQbXStQ?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: dbi-services.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 9629d93e-ff5e-4763-7383-08dcf8b1e76a
X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Oct 2024 07:10:15.4703
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b9c70613-b1ea-47b7-9fdd-e6f3a67ce75c
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: lZaobqwftsFlAksbMVFZFCzkmP8uzOQVGBM/dhl/N3speZ29n5ZMWoQwoluKOmuzgQSpKHRXwc3BCeXCRLWO/uU33Ub9dawO+ot93hu/+Sm0SeaknipLPigTO7LpCwBG
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR3P278MB1439
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/GV0P278MB04198D3BBE5F475C75D34C74D2542%40GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

>> What we've found out so far is, that this only happens if we have a loca=
lhost(or any other hostname) line before the line matching our connection, =
something like this:=0A=
>> host=A0=A0=A0 replication=A0=A0=A0=A0 xxxxx=A0=A0=A0=A0 localhost=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 md5=0A=
>> host=A0=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 xxxxx=A0=A0=A0=A0 =
xx.xx.xx.0/24=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 md5=0A=
=0A=
... which is quite hard to do if you don't know which one it will be=0A=
=0A=
Regards=0A=
Daniel=