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 ) id 1t5sRZ-009B3f-9I for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 20:03:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t5sRX-002bp6-J7 for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 20:03:55 +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 ) id 1t5sRX-002box-1i for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 20:03:55 +0000 Received: from mail-switzerlandnorthazlp170100000.outbound.protection.outlook.com ([2a01:111:f403:c213::] 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 ) id 1t5sRV-003eMh-D1 for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 20:03:54 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=dyx6SbdB5wQ57zQXhDCKHpGH9n5K57MGm4KmC9Tv87bAc9KkIXo2l35F/wIjgDFIoZI4p8oF1CtrFfiwl05g/audEEevK11bRKoWDREIvwBcM+gmcGyGqF3cMtutzlOi6qQB3poVvjwlaje0Hv/q1HZtwNevKZzG3dOvzHbXHd1d2kUm+HUgbsRZMAdNUmdX+tXG5DwVG+kz6zldKXGk9d5UaPjY5A1gqUo8pozHv9ATB/0EzSC8jxU2XIUmoU3GMUrG1c0cNcy8vyTDGFvJ1ATvtg76ZME1fxVabZPtZhKygiKvgFt3jI8V5UYXpAmdgOdAfVWHAuP6PQwzbJvvPA== 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=u9C/mWB0RIgl12Xuf0iCY5kGsjZBj+AVEh/qbYHLmTo=; b=UxO8ucaGW+2fAAdqHDAbuUEQwhPQujy632xRyQbn7xAl4Rxj5T5FLl/rbBrLt3zfEV4ezC1RzcZRQG4OLmkHqARqHJXQKHjBttRFRRaXZs49Dg3IppMPJPasT5JAjFyST9Ve0FXsqARH3AvcH6XZmfvuJw84obR2jAcYq1KLPBSupI5IP8iBPgSeRxDRvZvsUsBR2p+l+bFlTQdesjB6bdlv/dAzUAKS8g15pyBMpC+fZ8GuzvJKvcSuC/SXuPLWnaDFnS0MTn/L9aLgZuhCXa4Rky7Xd0dyCpCErYw/vmMBrbfnY2X6/xsiUtTlzamBN1nmz3y8LIT6CWH3vJTi6A== 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=u9C/mWB0RIgl12Xuf0iCY5kGsjZBj+AVEh/qbYHLmTo=; b=LWaQ3WIUm84/w3Ljp5mDrvupnGplDD7P3jlCqscvImZ0UgOponw6Zq0dD+KsLKSUKBoD9N059DFR85tai71G1YeOe/3BuJTZ3sFYp+FmnGgUZk1srnXgqA1IQ2PyiNyMvbreEiZucM36B618Shc5Oa0LXJ2+o65lmU1m4Wed408= Received: from GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:2f::6) by ZR0P278MB1351.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:82::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8093.29; Tue, 29 Oct 2024 20:03:50 +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 20:03:50 +0000 From: "Daniel Westermann (DWE)" To: Tom Lane CC: "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/rbKd9XYAgAAxSDE= Date: Tue, 29 Oct 2024 20:03:50 +0000 Message-ID: References: <249664.1730221572@sss.pgh.pa.us> In-Reply-To: <249664.1730221572@sss.pgh.pa.us> 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_|ZR0P278MB1351:EE_ x-ms-office365-filtering-correlation-id: 87f3bcb8-7785-4c6c-896c-08dcf854ce9e x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700018; x-microsoft-antispam-message-info: =?iso-8859-1?Q?AmtC+kUNpPUiiB/HyaXOVagMNEW9OxomdnE47L9pwFY8AfRqbP2yAdjd6g?= =?iso-8859-1?Q?Q9gUqCLT5v+v0aDO2FNlhyDO3hHD1FA6VjTjFFD2I6zsuNOzU79JVH/SkM?= =?iso-8859-1?Q?MNX/JnZq8UCWmDbd9jZrfDXPBn+Ftm9YUi2Tdw6C4vIcoAUUWaFmu4jkq9?= =?iso-8859-1?Q?O7v+kDXABodNKHjT3dllXQBpWUM7XB6iHpnHaNTkdkpRfjhW2ZsfBBv1TN?= =?iso-8859-1?Q?j5X8Be+yelYkNltkaaW0tSb6gz3AiQrYDn9GNBRKfCR3i/I61AeXPk7xTa?= =?iso-8859-1?Q?kk+2JHJu6978bZb8pgr4pV3+o0bLWj1PnfmS3+aIQG7kMTNnwl59783Kj8?= =?iso-8859-1?Q?LxprPZYmtxN44ps9mBJvorV9PkuzgAFkE4Dp0OF6D0QQuQrAQ8OZ0WtXbe?= =?iso-8859-1?Q?y/FcesnxIIDx1s+p7vEg/Oxmqui71ytm9TxpHV7vjGSK6vz+kgby68EtPF?= =?iso-8859-1?Q?G7EMc/Sw+rsa34lhlBnE6+e8fOciXI6DcVv26toKudBllDv0k6kSfysb9U?= =?iso-8859-1?Q?3z9nkmgi+eXc+PZ742ecf5Z4JndfufvDB3elw6gjMZNwfLuOIYlGXLFAjv?= =?iso-8859-1?Q?jt6PXkaiLAtYi6mQY7J36wW0MSLgu3yft3fjCOaKDk710MQbqjrDvMrNIj?= =?iso-8859-1?Q?VpLhwGm04lGsfLxGOQWFTR1JWeRNXhDCzwvx8Y6QCmZ32N22k4yrPcOOKU?= =?iso-8859-1?Q?1nEGnccIa1+58UsNj9Af+D4RqUOEKIDqIbQzPWzdCB1GSPILFhlyi+eL4K?= =?iso-8859-1?Q?ZSt1tPQj8t3RhO+rwmdodUVuwFGbmZEG50sR1jS7O2qh10G5mfqAJfe2jU?= =?iso-8859-1?Q?/thXzLefPkttARIrh/WSett9ve7tvZr5T39DFk0oBZgwJqWw8I9H8ybtN1?= =?iso-8859-1?Q?KUZLtuUKTxA1uBrQ6I6Y6wbeiNxcrcV3dMt00Wmq9wGKq2iN5wI0DP6iLn?= =?iso-8859-1?Q?ZcyVQa/ce1/mTN/62qJVBrpadYGVD0cqcS86EJX5Pi9aORQsSnzMN3OW9F?= =?iso-8859-1?Q?IdwuRsK8/ERqMrSvz0Ju9xz8nBQNw26m0MRoABefjrUGZ0z1RH0RdhXOFk?= =?iso-8859-1?Q?xATNUv9g1htApUjBr/EiuSo9S5OQ7Vd5NI9DzSTfmSqwdhFyiVhqsHmFKK?= =?iso-8859-1?Q?kb/MEjHZbCLd8xhZqjrj5le8AZSf/RSi99XkA1Oc49ZjmCdtVsFoDGrhD7?= =?iso-8859-1?Q?XUyVZUf/nJ4CCRr84SyzEDtPEJMN8XWiLuvveuJnmI8P9pWqmEysaJbbqW?= =?iso-8859-1?Q?zJmGyInfQ33fJYS2oj1f83Xqma++Kvip/a1ow8Q83ZdO7S49w7mcWlkwxT?= =?iso-8859-1?Q?f/pf22PRiMpBTgtc07lEXJfrSJw8w2Is02BecqoRiQXGaq23j54hMIR7HE?= =?iso-8859-1?Q?pgCznTkDp/tZmtNxQ9lGZuZZdVRg8Hm8ydqBU9vkBUu5aZ1b1b7s0=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)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?za4f6JR8Yh5nZBHgaAlbxYOOkf+cLTLmKYbyNO+gq2k5T3N1FG4AbqDu+h?= =?iso-8859-1?Q?fsWb3x1SmLzeTkJsBcQcoyzLv1x7EU8GSgfDXVzCHy9R+/SSMitIw/Rovt?= =?iso-8859-1?Q?v84TpRtKrnFo0Yl+EgON9q/NEhUYvzpMX3L3vRX7STBvUJJwQN7OYZr+bH?= =?iso-8859-1?Q?I8NXRGc8yI4w3Uwl4CGWhwR0eOxxAwCeej/ve8ijZrYVvf4xETkIhWss4j?= =?iso-8859-1?Q?o3+K25iovGNw9A08LqAVVYduoQNw1I04swM07d6zqDFdWPDAd0XuOAfsog?= =?iso-8859-1?Q?75rMQ4okRk4P+ruxbZL7Gy+MTI35kzLY0s4LLpS4+9/yHoZqB39i+qPp9n?= =?iso-8859-1?Q?xATk4HHhPhEJ2iTxyg8iGIAClB/LLPJ3HmRht3dkxQhlU1zxC0UjUkxSnr?= =?iso-8859-1?Q?FOQUJOHAAqBY8nHkyqcMT15ZSIHS+W2Mez92/OeW9afJEBUX5fjwVmffvq?= =?iso-8859-1?Q?4Nw/j4o5WNXTw/AskJVP6HNxTP1tq5nX8D2VQxVyvvUxT9Ds0lzsVateYY?= =?iso-8859-1?Q?Zwdc3gpPvYKQ9qZQ9HmolyUGhbi7Rz67QlscooOQWVJCKklNZhjollKhcb?= =?iso-8859-1?Q?ya1JSZaMETT5852RCemQpFxYaP2hKDVcQSzR6rq0u2ao0t/xPiZwWLIAcR?= =?iso-8859-1?Q?VngbgyfAhwgv5RkdqG3hxLPHGzSK563QYBaPQWDOa94vsxTUsiJpx/47rs?= =?iso-8859-1?Q?7roUttz5M+v3zhPy2NEshPLgL0oro6LY7OCN3wMDAoZgpzO/7iqzz6CBFz?= =?iso-8859-1?Q?fnEXf3dM8eHY7uOezPxTO5hcZCqG4qfOikl9hj/A/OJ175Cy4b1F+BCm9c?= =?iso-8859-1?Q?RE1Tv6grU/SeIU41/vSdsOI/Stuce4sLnMG3NaJedKI0G29Vs0+cOs3n3u?= =?iso-8859-1?Q?qs7B3cNwZERuePgmP/l+YuW2neW0Lb2uJg/dTlR0VRXRQbg+lrfCWle89m?= =?iso-8859-1?Q?QvK9qHk0upm5TxIdNGYKQCi338jA+X+tWP+QDzSXIIjVimAQuUxwbRRIGM?= =?iso-8859-1?Q?o1E2zUGsB9RLtA1kFNqmGQ+8YyrnBcEAatm7L01EOoXjj3fyoCVz4KKAf3?= =?iso-8859-1?Q?rUOq1MpiFrZt/7DozqAt3JIVgCipv/9lvIw5xBudo3hnh+GOP4p27OsTtC?= =?iso-8859-1?Q?wX6RGJPmmKdU39V8KXPPir7nUkRG8kphs6lKJl0Eebhhg2zlqxEF0qHRNK?= =?iso-8859-1?Q?j6ogcq56U6GnV8yDDLrizxqFYMjS2m2NhH5Me4yE9BCGAfNFCJ9FMARtZA?= =?iso-8859-1?Q?FpX29b9xgRYvL/nRfrPJ3ql0OjdKFLmaOOnHuATv0aUwXcULatK9TquWm1?= =?iso-8859-1?Q?AqbrWYcAB+qlAT7UTBO2kXavduONW9kScoirrlE6lqkvAUO6MhKw5r6Gsu?= =?iso-8859-1?Q?SUACGAzvOZr22/t1DbPsXPXIDBOOxP3vjzy6pBGfRw3P3E61UMvtZkIFTf?= =?iso-8859-1?Q?NnvPSq8/LKTqyxKusTsnONizUdzSmSmBRQCw6bSQKOdK9pSPncq8404K0o?= =?iso-8859-1?Q?dEVq9tXmCzjHDkxQCiD3FfNHQgq4d1O2+hU5VP/4ytoFcK3LTdKRRZ1nYI?= =?iso-8859-1?Q?oC9m1b96jtnro0O2qDYoYWnkylYYgtD8/x5sNnJx3X93zSMJGxBWNpqhJW?= =?iso-8859-1?Q?KUtDdgwjKJnR3M+Sd7fFY9TZcx6Rh8Y3gsbsVtkTm8xaEIwFisuFhEGw?= =?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: 87f3bcb8-7785-4c6c-896c-08dcf854ce9e X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Oct 2024 20:03:50.7184 (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: p1yg4R7guS8hCrx5ji+sSxf2AvRicLcV+2CcBdvSiBlaBolbshiqRSsG0mFia4aQ70tyuLwUyzAObJ5WBE4xoj0Fmk2Jbvl+Qv7zciWKAOaYzgrBFwkutXsbjzzvuG8/ X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR0P278MB1351 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >It might be worth searching our mailing list archives.=0A= =0A= I did that, but was not able to find anything useful related to this.=0A= =0A= Regards=0A= Daniel=