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 1t5qF3-008uuy-7E for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 17:42:53 +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 1t5qF1-001D4j-Eo for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 17:42:51 +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 1t5qF0-001D4a-W6 for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 17:42:51 +0000 Received: from mail-switzerlandnorthazlp170120005.outbound.protection.outlook.com ([2a01:111:f403:c213::5] helo=ZR1P278CU001.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 1t5qEz-003dFa-6D for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 17:42:50 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=k7sIqjLVfyt6DwhaER/Fe/KK2TjRvaSya4RbuSoWn7eNKDvcUDrL4w6wxSSU11ZKWP0+CqCIxemQzRmoampqgZhjhjC4mQ50p/praDMOrUeDlCTLL0wJEbiE/mq3KUEvXTjtLZf8YLJ4RsireaJ4FJU1/ycRaFh5zlqtqa+cTvf0hl1DCEftWC1GYohl+JDsTUVsOw/mZGvR8AOshf/O6WSxhbZtRDCA2oFX3zggBOjhjjWMEs+1SE0rMgYv6EB/P0YGB2v5Pei1xIGAJRpHyydbgPfnZCxS6BrlIxjDfGPjJtYsUeJzHDLv8gtnOMEseAw1b+nCn51YJ1oSoRiDHw== 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=f6pnIj8OqTluaJWHf4ZyWuQUu6jxh2hgotIFjGnoF28=; b=GSseGeUPDvYEsZB/vMVFdRnq7UbPDEEutFTQB/BT1VEDKWenuY2V3tF0nkHPSIWXjgtbTfWtlRSy2DB7+q+6fE0v3jKJSbQBUjQEcoRJdPIgpEnPMivh9oJBCsoRyvoqBQg54aT8FLyLAYdROPML3clq2RLZa1Lg/QvsUAwQVDyIeeJwjqzQWaMp8ycdXYlyNUpxN0gqibbOPUhmPdnnxenTi3BtrEmBI8ZvOsGxl8wQYKFvpXAm+e61bF98craGSoB8JzjMD5oSBOlPTEfMZQQAS2pULuELen1VqVXM164tGrBdtbmJQBfoUVl/Jmafan9+3Neamwh9zJ7yEEteQQ== 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=f6pnIj8OqTluaJWHf4ZyWuQUu6jxh2hgotIFjGnoF28=; b=SbDLm0rt5ohm8eDo6YEl+A9UVt0YWEotcuMhvHJ4C5nCmXNQtmmjOVZDZLlhkBaSqllOts369jIor/VFS2bpDkwWGeHAPxutQGjqMnNci9VJRtBkQRO6E1c/Us7QpZN2opLQjtwGkCeQL1ZKpue7sHKtrn9nznjcwKJuNXr9l3I= Received: from GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:2f::6) by GVAP278MB0809.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:47::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8114.20; Tue, 29 Oct 2024 17:42:45 +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 17:42:45 +0000 From: "Daniel Westermann (DWE)" To: Adrian Klaver , "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/rbKd7ZuAgAAREf4= Date: Tue, 29 Oct 2024 17:42:45 +0000 Message-ID: References: <792f687d-5188-4beb-b94b-3d3edeb384a3@aklaver.com> In-Reply-To: <792f687d-5188-4beb-b94b-3d3edeb384a3@aklaver.com> 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_|GVAP278MB0809:EE_ x-ms-office365-filtering-correlation-id: 511c67ea-11af-4390-fdd8-08dcf84118d1 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700018; x-microsoft-antispam-message-info: =?iso-8859-1?Q?iv0Tiw+j4UpzEklFgrHhNqMqZlPJzxunTbOX02zqYdmd6Z9RTHZI6KEeCU?= =?iso-8859-1?Q?N4EbzwoB2TO9M7eOM/Mb5ySCCDoWFZDl0++aAHbBCBwOhG4JRLbpGscyXc?= =?iso-8859-1?Q?SXmni9wJ7QmDrd5QujURzURDrSugaskTVKrCMCL89grDY7INu+6kSBmDny?= =?iso-8859-1?Q?hEJah4waE6nn/jskLJXsFuoK/Pg6BVPTYUN2Z7Ggv+rO3hAxGAi2/A+Ffa?= =?iso-8859-1?Q?t8jYpuafoT3r+P/NvBwDaCMwiC6fQ39xvBXIBcC7jSwg6WJzMCEOipku71?= =?iso-8859-1?Q?fUaK+4zFc7EaDDMVmb5eKL5iXqICF5T/LmBKROHAMAdrOamRRjto5oJKnJ?= =?iso-8859-1?Q?ntfxyy1xRgg9DPt6osKzbALBJgopu14qgkj/LCLwfFhIMQNcdYNYB9yg1q?= =?iso-8859-1?Q?GMMAe7kK9D3XwD1xqlL4GmlzYzj/t+le0BEPN9zcNqPWormoiFMMLoG8g0?= =?iso-8859-1?Q?kWhI5LIEz0EUc0L8WSwwTe+dpUqM2gUUatHD4IhcH/Opb6p1do+hPT8CFO?= =?iso-8859-1?Q?xkzCQqNKJRUDSz9578aKXQfV+suWyfFiSqUDEtS8ruQTGFkyqO8VQmf8VD?= =?iso-8859-1?Q?1E8Z6LCz9d3VZO3xgOQuXD3ZhCfx1+ZHIxfCuWk0PoY+qVtreclps5k8qA?= =?iso-8859-1?Q?tBqyrUR1CAUeCnpKhfWPQq+v5Fw5hr0yLXmYsnh8UacWmF5R9cFvSfno+r?= =?iso-8859-1?Q?T7zVn5+gzETLp025/RB3FjhQfvL9r1F/wpHFpuZ6lUmybMvnRbHQsiosrc?= =?iso-8859-1?Q?oCCRHI4NrQocuzHYpQ9M+KHby5/p8CMhX+bSRI43/2f9EuPgZ8DpP2bVEM?= =?iso-8859-1?Q?rg43KisdZ1m++TJaKELBNtXu9Rg9t7ioJ/Ol0nYiOczEDk47HQGkuQE8+O?= =?iso-8859-1?Q?fYaeI4AidaWRfW903VcQZXsTrpb/oHFVe+s4PuochsvFjyc88TBqEjduYj?= =?iso-8859-1?Q?+2QM/NN3ouMCFE0NtSd9TukcE+l92umALUbJT95LGyn6wbJrOixHP+6TRI?= =?iso-8859-1?Q?bvNNTXPytyypR0HyyxTsanaipbD9kC3AoQt/vMyRwVpLW2B4TiaMh7p8I+?= =?iso-8859-1?Q?U9JCJ+ic0FfJEXPpivetbxFg+wUbmwSabWSKgYWryA9BNxIWHPdR6oUtYV?= =?iso-8859-1?Q?EHmsOEFlQ6dmc4yuKNH76/ng//L39Oe6wUNuxgXlbrI8KgRlBhswWsiBRk?= =?iso-8859-1?Q?ov2W8SXGMFjPXIs0hc/Htnd3cyPtpTaDhaEgJ3mIvHGDDwcnASGNQ9fXBc?= =?iso-8859-1?Q?59+afWnzxlf0wX8B4BsZ3LLWny/uGjAbbLULPLlk4va8pF48/auP9TVXoJ?= =?iso-8859-1?Q?/GV2oCByaPeXCBSr4eG26OKnMtRnvTNgxBYUS/aOncKEbeUAOiqMqNRwSk?= =?iso-8859-1?Q?E7oPtdLZQtJU+A4H/23CLtY+mPFKEJC5LnuU8Zi5LL0WKPvcym8IA=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)(1800799024)(376014)(366016)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?Wj/Sn4BUahW2aV6PTNh4llqBE/eUOjK2vdWlMiQD/sDGziygLUHl2XffZy?= =?iso-8859-1?Q?zpjvK6Ek0EDhoTdPOdU3x+lMw9ERK0p1G7aPpJJF7eMttuuPsJHCs5aFsa?= =?iso-8859-1?Q?5/3MhxfM+0+ESPzYnwX5QvkYnhBABVXwllixFHC2ISWqeIz+GwXAsRZhz6?= =?iso-8859-1?Q?UWhuSVQsVaatrLZAtIztWFa/vFW2dq6+UUADYi8O+i46BmC4n/FpoTx41T?= =?iso-8859-1?Q?3jgNUQLnHt5Ux69u9a9U9vqtPd+Srlsz06neeVT8HIIEHYq5W48BBEDiq0?= =?iso-8859-1?Q?OYw9dZEk4n/m03pVVGYyNbvakOmZVwTccmRcvW/huq4DjlKypmWa8dthrw?= =?iso-8859-1?Q?RMQeQCT/0lGUvRjAe8NFGzHQdmL3k2Wk5fXD2s9Xm8fFTWkCc1C6Fseqw3?= =?iso-8859-1?Q?2dpfEokIlU8zlsh5Li7AD3DshJpqhRh8kMAAxB/37yw8AJ2B26g5qJBVBy?= =?iso-8859-1?Q?/DXOi6WATKzBA0AUwwjP9ICRRqjXow05VjiYIcxsRgqPFBGU3aS2McYd4M?= =?iso-8859-1?Q?lhZBqtaiJChsApHy+g6C5iE2QSaEcBb+bavcjx9PdSpWWW8iaB/4NNfmWq?= =?iso-8859-1?Q?30hIW7KUNFI/ObSoyMu9cZD8yhtBxKbrCFjbnUMjlvJf25JI1gw54B5iQl?= =?iso-8859-1?Q?0cJyswzp1UPzfz/EQgCiEsCbExKs+eEJffZ5KQ1wxotuKi+DixghnCL3D9?= =?iso-8859-1?Q?FGtv+FVZhMsR6ify6NQFZ5d7f+PuqvHP5Gih2VZiIJMTy7UfoO7xmBJvEy?= =?iso-8859-1?Q?6+zzSBISxiAB7NNMuHidqXRdlCbijwsUG94iANfLJO1MsDpPWuFvm8gH+B?= =?iso-8859-1?Q?jXRaL9vf1+ADJ0xqJZxu1cHff/y5G4yXlQAkjstEFE6OjRlmYYcA7WN79p?= =?iso-8859-1?Q?K/918rutJ/Km5hiDcBi21jGZ4VCANh3n3+IcTrn/wbOfXMzYFK099LjJ9M?= =?iso-8859-1?Q?b+439in8Sg47xlhZ15/1nGJkwGhiXMxMBcHCUIYM+Q6t2ZzxJPDMGw8DGI?= =?iso-8859-1?Q?FtYs/LhknnHbbnU0J4TphueyglMJKpHo242D1loW4JG1ylsnH/f4g+wDD1?= =?iso-8859-1?Q?q4CRzAQgQcn/lIQFbeDTF9e6XF/YHrDt4fO/hye+gz5UENjPGkL3phc68L?= =?iso-8859-1?Q?6Gr14ot2jU+VHf8zfhBzNhjvOlw6dcClQ+WyuEqkxQq3F1VbziS8vU0GLU?= =?iso-8859-1?Q?TO3XpwYj0WCvi7A3Q7m7WfqC6pq4jL3gNJ7e6ZqdG5ApenXv2IfN30WVUq?= =?iso-8859-1?Q?NNjztLF22B5Ou1DzCMmApuEpXo13MWFQobM3HUhMEirU+9To79R5XAfwek?= =?iso-8859-1?Q?zHJHdCymAUJ9OS7tTpUGLSo1J6/By42hVBNuYf2UvYfg0vq/l/4tQWaiKO?= =?iso-8859-1?Q?Rj21bgmuUX2OS4HVguXJ+GUAqTAot6BwOx5ivdaQrWbKkBm2LSvv9zidMX?= =?iso-8859-1?Q?J3IBNIJ322kwvKCD0ZWO2tEYGNt9XKJMPpgqe7F+HUrePG2h3M9exnCWGQ?= =?iso-8859-1?Q?pEgxjxRYR4o7MHClhkVT6kYIFoWHsCUeK6AADztSf3WJLzWbdjkZWNtl9T?= =?iso-8859-1?Q?R8Y0Z9vAupT3C8dvHGz0RGhpfZWjlUPEpyaolmDIZaNJfp3QDR9EtWrlq/?= =?iso-8859-1?Q?GObXj+iDBYFeeanbdRBOTJ4xRha/ndCkL5FnNFeN3iPWwqGWrgnjbLwg?= =?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: 511c67ea-11af-4390-fdd8-08dcf84118d1 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Oct 2024 17:42:45.2536 (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: o6yqbSXEbS8pNVvhHKI77RrIY//THt18v9kkTKmWPI+oUF6IO5OUmucyRisHNXz8aDUBsqfCxW/eGPTCfW2iKNffc2H09hOET0pf6UhfyIHe6d7F1cb2PCu1PLMBFrJm X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVAP278MB0809 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > 1) host=3Dxx.xx.xx.100 =3D localhost?=0A= =0A= No, it is not=0A= =0A= > 2) In postgresql.conf what is listen_addresses set to?=0A= =0A= * =0A= =0A= > 3) What are the settings in /etc/hosts?=0A= =0A= Standard Ubuntu settings:=0A= =0A= 127.0.0.1 localhost=0A= 127.0.1.1 abc cde=0A= =0A= # The following lines are desirable for IPv6 capable hosts=0A= ::1 localhost ip6-localhost ip6-loopback=0A= ff02::1 ip6-allnodes=0A= ff02::2 ip6-allrouters=0A= =0A= Regards=0A= Daniel=