Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t5sJv-009A0g-VU
	for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 19:56:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t5sJu-002UHG-2r
	for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 19:56:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <daniel.westermann@dbi-services.com>)
	id 1t5sJt-002UH7-J4
	for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 19:56:02 +0000
Received: from mail-switzerlandnorthazon11020126.outbound.protection.outlook.com ([52.101.186.126] helo=ZRAP278CU002.outbound.protection.outlook.com)
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <daniel.westermann@dbi-services.com>)
	id 1t5sJr-003eIh-R3
	for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 19:56:01 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none;
 b=u6d2Pfb8fkQGywNrafmAmz+ebrgG1jKpapcayes9YKZLB8cWPVqROm++Hki/SwR41kDuVT68qA0IoABAAj/mK5I7VV208ItOz4WL5hT+4ji51Y9K3el+oYl1IvonEzaI7NXuSG5pO8pmVyzDZLFH7j8wfxsK5Gyt3rvFGxvhSjlodCg22CFqcAwUYCWQrTsOqEujLb9igx/YzpnsDf6dtqeY1VaO9hR1Q+anAfQu6HBIVV2owejom/i1QNHkoTjaorwK1rghBS8OL2tD6umzEwgcLkbCpA9NOk+hyb4geT2z2ElMq4hfGHqZfcbXVG8rBwGTquO4ms0s2G5r+s8KBA==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector10001;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=LAL0cEu+k6BNGMmRxpGno+w+e2i+8lemNv+x23X5LhE=;
 b=n+0VfJxc6BvojTjIWKQSrhjQeWoIE8hDDdVINa99KQw/lYxRY6eg1AyDLazst5K8EVbL/QlNVc0yzAD0fiTQl6rUjc4gLOJuY29cgIXtA+aFoLfSWfpsqfPNXiRUk/mhFZGSkmRgsqxH78VyQbT+CE8iC1Cd/acwMREmbSIgefeZHWwRkJQmrCD0dijNd+xlc6seb/JFUPFjZEHfoGe2GZWr+W6wG18nRTQdoi+KaK6wSWTD7VEfpfkRvISvpT8Gq7XI76N8+wOHc6KsxxkpaKuLQHOjT2H5tHLLwLwT7fH7/PZu7OEMD1hGkacZYyky5yxSvdWso30t1J1mtPT5Vw==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass
 smtp.mailfrom=dbi-services.com; dmarc=pass action=none
 header.from=dbi-services.com; dkim=pass header.d=dbi-services.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dbi-services.com;
 s=selector2;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=LAL0cEu+k6BNGMmRxpGno+w+e2i+8lemNv+x23X5LhE=;
 b=hAWMNvUwhEj47aHlm3MZtMG93HJQEPTqlmM2qEXqS0YVC0xrTP7kN/aa+F8KO5/abG1ItIWmbmp3dFtGoKNilwAVPhvS8IQwmq1OPLXTcIgwTHJgf4cvnkXsWg7zHf2lV43OutO5+WKRxMeWw4TXw7M5ABF93XaoO+YaMs9cgvM=
Received: from GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:2f::6) by
 GVAP278MB0040.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:21::10) with Microsoft
 SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id
 15.20.8093.25; Tue, 29 Oct 2024 19:55:56 +0000
Received: from GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
 ([fe80::2f86:4069:83c8:9fa5]) by GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
 ([fe80::2f86:4069:83c8:9fa5%5]) with mapi id 15.20.8114.015; Tue, 29 Oct 2024
 19:55:50 +0000
From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: Alan Hodgson <ahodgson@lists.simkin.ca>,
	"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/rbKeDg6AgAAWopo=
Date: Tue, 29 Oct 2024 19:55:50 +0000
Message-ID:
 <GV0P278MB041915AE6B98FE7BE44BD067D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References:
 <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <8ec9d0b8dac0e38075c9630f02ef25b088f290ec.camel@lists.simkin.ca>
In-Reply-To: <8ec9d0b8dac0e38075c9630f02ef25b088f290ec.camel@lists.simkin.ca>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
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_|GVAP278MB0040:EE_
x-ms-office365-filtering-correlation-id: a3673552-b42a-4769-d9a2-08dcf853b023
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam:
 BCL:0;ARA:13230040|376014|1800799024|366016|8096899003|38070700018;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?Cu9QP898/ilt1FY3lfT97Hy0Sh0yTdZjxaEAVzTHONVCIt8bHZxrHdhdN8?=
 =?iso-8859-1?Q?Y2rpt5wOnfO2sUnjjxHXRgon7sbA3VqXCifiGA6o9mAZZP6Kp4SlYCAooi?=
 =?iso-8859-1?Q?j7CJptBHvyLEW7nSYpuTpcKLaLEJ5n3QJxH+Oz8zMzbLFBIDq1YYC1ZFl3?=
 =?iso-8859-1?Q?DCdzu6AKka9IDQOXOoWseBo+bpCE8aIi1EXKip8m7RWfwusA2dIziXgfro?=
 =?iso-8859-1?Q?7HPnzcnlFqDCEf6CvbJcZfiWAY2zK4SXXjoxue13Ni7pLwZR1ZQ//PHLiR?=
 =?iso-8859-1?Q?Mp6Tb8NuiBD1d0lmAq5Zrs8S9qgg3nTtGhGnBqEAORxNfiVewexCZEXjA2?=
 =?iso-8859-1?Q?BNpKrPUoTNPRyPSx2Mg/38Jx7I66MWyyAg9W2fq7YscH/l5LmcIhTlnhNL?=
 =?iso-8859-1?Q?ZlxkwvTj3jCs9xM3gybBf6utLXGnq9WLg7M/iPB3HW8wGaBNEZyap8xt9c?=
 =?iso-8859-1?Q?0J7yShGAeFv5B01vtGF1xtlMY4ARmXmbM+NGH+sjSQy/H3a1+xv4ql4rtr?=
 =?iso-8859-1?Q?zQ0jNur/d+mGVmSifKpQ9vFeoGoNFl+HNDsQUYTVEKyiquXkydPyPhDI+H?=
 =?iso-8859-1?Q?8g0t2qA9Y1wNIQSMAzyKrDPcIYdzOhIdnLZGZpAJ+YoNOFwZRXAIbWJXzt?=
 =?iso-8859-1?Q?EJbvSSEGKWyMl6GfRiH7BEF6a+nTXjwIla0UfK3Mt/B1q4mJ6a+aGtN38K?=
 =?iso-8859-1?Q?5Nc8GwZn/o0lTZhED45h0cB1qRg+65+d5j45ALLCjvX8QFSjThzlAfaIDQ?=
 =?iso-8859-1?Q?z1i4MXO//MQayLp/KQq+Hz/q2Qv/jVtOccPMl8BaQnjR/n6GJRJhEfwG1Q?=
 =?iso-8859-1?Q?xmvj2mCPv/DVrdIjnXP5Ox8cDQxCETzi6OS1KWflxsC3oHUM0pyMi7IJZT?=
 =?iso-8859-1?Q?5mWA7F8Z5FLX61v2ZGIAxW8eL5yqeTkiZLfTcyTLzQZoKcNdoSsEfcOvu0?=
 =?iso-8859-1?Q?PZ6Rz7sq8/HkF22Ygl61v2bLsjT7ChqupxVwBk+4ah6JKfiFhoygljsS75?=
 =?iso-8859-1?Q?sAIlbirvrXnaKztIg9uEH08Z//eijGCV+oH0aCtgG5cvSVNynuJNKCanQG?=
 =?iso-8859-1?Q?LGZr0gaY1JwEfktVtDH5/YCApEAT2yqyGCR/7smm6ar6C78LzPCDdWK3/V?=
 =?iso-8859-1?Q?K2GmZc8xt6QXaQhM/fQ0s3PwWkPFt+G+imrmXg2P9Dm1Iuk6iZNq7NvXEH?=
 =?iso-8859-1?Q?Aaccjw2wZ8/l+U4sS8pc68enNumx2ZL5MxA3LdJp3fpnjZGUGkkmiPFxAx?=
 =?iso-8859-1?Q?a2dzqLWqbFZSV7Dffxul60SZYw8Ds0acH7HKpyYSXkuPCjuIcuPBb1S1XA?=
 =?iso-8859-1?Q?TGb2dcVsZY+/8NMtICHQUNaA185ZeRGLTTPil8Jr8kKHoUZfLvShmxxhyW?=
 =?iso-8859-1?Q?dUkSVhxnBBBtbnoymGMTW7PEisaJMzIuUeqtGvJxNvW3xPMJEvK7s=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)(1800799024)(366016)(8096899003)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?voZkIzDbB4U+2DLa4JDQQeb5H1s3w3OkRh1SP5Y+DIu3h6Laj6izsa6zVU?=
 =?iso-8859-1?Q?O++CNxbnNlal/xzdL6i+ZdXSq0BMYCw5w6TBpao8XOwy+AObAlJKxn9+Qu?=
 =?iso-8859-1?Q?A68IUu/q8MVsdvDBP+v2tDyE6t1ckT+VnGXgC1KAG/kogztetks3YLFLs/?=
 =?iso-8859-1?Q?I+90T8UXCsEw7//kgMZjxgh+czvWcTgInKh9cvn5JSYn/SJySQqjf9S7FA?=
 =?iso-8859-1?Q?k+AdBQQy4g5U5tWcKtVC4RrfRbiyo3B2utLivjP+gspCgbQGVMx/dMw1zJ?=
 =?iso-8859-1?Q?yIq/Y7RZqyXG67dUvlWcl/3q6GM9K7IEhvWLf6duJTNHSNlI2zIIRTgeN3?=
 =?iso-8859-1?Q?G49SjUvvV0tEBvmgZ1kIAiBBbAg5xNRdwqiEWRW0KNbIeBDuIun9PVOrkj?=
 =?iso-8859-1?Q?w7SGmoQ6kXp4TsIx+xYz1IoxkyumjqPjEZjL0IfA0SZp/nZo1XRW2vR7ca?=
 =?iso-8859-1?Q?9wVH//ah70mXnbWcCZ+jH3MoQkKf4zGPG3CdT7vqa5HUQeZ/4oEPjQ14ux?=
 =?iso-8859-1?Q?fKMuzRwIhjFkqd00sJpACugBGR9wLkzVSCZ810DtMYy0pnAMkawnf9NnX4?=
 =?iso-8859-1?Q?Kuw5Zs2AVk9/N5sGPXpW+PT81HIK32a6ySAA8AYY3ofhL7YBfsZZP4xUtO?=
 =?iso-8859-1?Q?LVM1u8DswQEvoea5Ty6pRMwFkcU6+ZQYk/WmIldRNDV/6hIgCQ/JNUhsvF?=
 =?iso-8859-1?Q?FrwtemdsXIikSOKqAMcnZfiognt/Jjdj1MYnIr+Ga2ipIU4TT8A4lWb1qJ?=
 =?iso-8859-1?Q?vT8IZAzvg5dvkHHlVwvR702ZsoMwukaRSY4ZLAe4chRZ6HQU2c9taVOuXN?=
 =?iso-8859-1?Q?XTVm4yBvbLqy78NjudTidHxHIHEIuzQh9NoDFrJm1hd/W6RjoCDvEf4t3T?=
 =?iso-8859-1?Q?9U6GTxmsz/xZVK6F4MsKuxgi7MY2vqady6cZH/YwwBZ9grXXkZFCsj6nEt?=
 =?iso-8859-1?Q?+TTPsjFYcnHqr9mHxHRkoYrsw/RdCu9a8p/r+Bnvq/10ZJWFPIfa3O1Kh8?=
 =?iso-8859-1?Q?0OpICnqfAOCzP3sYKmtqUN47OyO46JOJp6z2bNpyZbYoYfvTNpvZoYav8A?=
 =?iso-8859-1?Q?k8vko8RKHCu5ro/kSEuTBtYJJYtXIPfqznZAbVaP2nuQ5KBa4VKueFgTcA?=
 =?iso-8859-1?Q?Hi+fNkrugVsms5AB0veJdjTTWNkXFev2tHQ5o1TMTbd4PXn/6P1NnGfMp0?=
 =?iso-8859-1?Q?ZPP627xOC5dIbn6rOl6vrSKeU296WKGoaho5omzcaV8lOZOHBlPGEZlIsU?=
 =?iso-8859-1?Q?Z55mPY6kZPA0PX/QKTFYEJDujrtuZHyYeNdZm+LU2r7Ez9hSFRJCgNRn0m?=
 =?iso-8859-1?Q?zbHOtvhzJ4LJT3eijXBMq+6pLTwJ87NFc+CxQpCHgoacGFdNCftyvGECrn?=
 =?iso-8859-1?Q?hUnkrKd5fAC6/oraXViTtZd9LFyLSO/oATzdwE78GrjpDsUAS1Ne0DomVd?=
 =?iso-8859-1?Q?NH7HusJEaABRCoX5Wm01dScdqjabn5RJjJEHFHcnLzL+Flt65MdrP0+O/Z?=
 =?iso-8859-1?Q?ycrwlKhajXF/0Y83D6vCVqzTLlptjpCXL/6VPzO0kVyiARRtMjTuapHNE4?=
 =?iso-8859-1?Q?os4dNdzdi8Qm6smrnxJu+EQPRT+liFDdfO5jRPdUSGev0HkYt0YgKVrpaN?=
 =?iso-8859-1?Q?OCMFmL+OaL/yPOw9DbNVTEiZo9XGxkG/KWVdeGhGS7fgeaBaw5N9KWaw?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_GV0P278MB041915AE6B98FE7BE44BD067D24B2GV0P278MB0419CHEP_"
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: a3673552-b42a-4769-d9a2-08dcf853b023
X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Oct 2024 19:55:50.0422
 (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: wUXpHnGZkJlW4W8TNPFGXOrBIzH3gAsUbT6vZGasc2/WXepG5HQRO0l/IEXIxNEk6qR5okwNAxJjNfOCRby8HgfaScLAL6VLqAsVgqFtCbBj+xTGiBP3wXcy2eFDd5xm
X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVAP278MB0040
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/GV0P278MB041915AE6B98FE7BE44BD067D24B2%40GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_GV0P278MB041915AE6B98FE7BE44BD067D24B2GV0P278MB0419CHEP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

>Maybe check that "files" is the first mechanism for hosts lookups in nsswi=
tch.conf.

It is

--_000_GV0P278MB041915AE6B98FE7BE44BD067D24B2GV0P278MB0419CHEP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
&gt;Maybe check that &quot;files&quot; is the first mechanism for hosts loo=
kups in nsswitch.conf.</div>
<div><br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
It is</div>
</body>
</html>

--_000_GV0P278MB041915AE6B98FE7BE44BD067D24B2GV0P278MB0419CHEP_--