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/rbKeDg6AgAADO4CAAAbNgIAADWUP
Date: Tue, 29 Oct 2024 20:00:47 +0000
Message-ID:
 <GV0P278MB04192D0C51E525B5D6443691D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References:
 <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
	 <8ec9d0b8dac0e38075c9630f02ef25b088f290ec.camel@lists.simkin.ca>
	 <CAM+6J95NCg6WNDjYyx42zjeocKXoPf7emci1zHCTboXGaE+WeQ@mail.gmail.com>
 <6e109baeabafa57970d7e8a9cdcb86abde8b14df.camel@lists.simkin.ca>
In-Reply-To: <6e109baeabafa57970d7e8a9cdcb86abde8b14df.camel@lists.simkin.ca>
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_|ZR0P278MB1351:EE_
x-ms-office365-filtering-correlation-id: 4b15d4ff-3069-47c2-aa35-08dcf8546174
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?5KLDIoVaLFiVQTck6umeNvQOYvuBXw2G6ylQxFcI6j/adk+NAKH/Ach0u1?=
 =?iso-8859-1?Q?uDnuNK2ICLqPv4oIR42MvRrz2ODd8rL9ugSVb00gvqIJcBltabDQbRp9Mb?=
 =?iso-8859-1?Q?X6ku+jMT9jNnYQ9lc0YAd+8Vyjdhly6skGtY45Ukez+ahNhK0AIe1W15S3?=
 =?iso-8859-1?Q?6zdEoD7vNhp+OPzj2YAMC8c3V81Wxs40mVdoLuPliXCvj6stL7moCJwJ9N?=
 =?iso-8859-1?Q?nuW8U1NO2zdi1/997sDM5tGDWC7TDpqBPImqjrBLuHOBuV3oB15Sk6gK01?=
 =?iso-8859-1?Q?VvWh0aNefNni7wCLY95bclOZBdqKIbq0RSQ9KQtRUVrMWplWUqHtavsobs?=
 =?iso-8859-1?Q?LaYyXaMKarJQ80/zcJ9rt9y0yGZkiMYtst0XOzUAZiB0Ci8vikISv0l5aL?=
 =?iso-8859-1?Q?ne+DKt+Qex/aW9gnfOCGzNntrdFaEb+2vF+FmYsmHb8BfvGJKvpMsY2CkZ?=
 =?iso-8859-1?Q?A6HuVKZBy2m8CJGqgM1NShMW5kcFy/mchTQP44Zye1eVRUGJ6pSAFP22qu?=
 =?iso-8859-1?Q?6mN4ieK4HoRbYCi/pYfrLUZiB01aAh/7PSa2rIoxryHvxYmOJSIcXhD0Rh?=
 =?iso-8859-1?Q?QZbTFaEwy574xS6OSxBOh1u6GAIFLTEX/hNDm0PDgZrSKSCGB1VvW1dRyG?=
 =?iso-8859-1?Q?NyT2FYrsvh9ruCxOOSHm6Y0Rw36O4k5PW6hU6iXRpD1z79z/66LuXhpH3k?=
 =?iso-8859-1?Q?WMrRlKCKNkshlJC82Dwxzt+K96/VMzRqWK7/Z47azhZvRUZ6npwFu5DpJE?=
 =?iso-8859-1?Q?YbUUoLggkNMMxNnJEkE2ZU0Zz+7yI71c3oSJEQFxbSDLxIKTYTeMIVyM+x?=
 =?iso-8859-1?Q?U+lN2d3hbbwNvlytSSe8/v0Wc60R4pDMLWMgmUjVGSJaeVwL9WqmZ50ad2?=
 =?iso-8859-1?Q?mNB9FhRZBPjuMOg2C2XRFKsIVQB0okPloeiAJNYJqrjhIxUWBQVDhqR9BS?=
 =?iso-8859-1?Q?BptVM4QDQcxvznsDfbuU0rBp5U8d1XOqKWIkN4xtRVVkvxvjlBWhR4CqGt?=
 =?iso-8859-1?Q?P8W/9Njy6wRZYdU9Q1BcXBiQoj2zbZ8/M3IzP16+XZeBeLkXWCvhi3cXmj?=
 =?iso-8859-1?Q?uljvROTbObia11quSE/1ynmoeYIUhDhdp+dF70Z9IpmkyB4zKechz4OxEy?=
 =?iso-8859-1?Q?Lj5muDX4e+N2htXMBtHqX5otWkVAyg37IDRI6vGNdUmXlpsbl0TY0Akcdl?=
 =?iso-8859-1?Q?HPb+SVo8eil3aeGWDKlwRcHuJbxETcJg1Yf3gIhgxdgzur1A2Iz8GmE//x?=
 =?iso-8859-1?Q?XLRHwfCIw/yT7mTTsUuIk7QwYJjOX7eOZDeyYRpgwRUQSVqTJJOmhbJ22U?=
 =?iso-8859-1?Q?XcULiFNEvr2BPTMTgxuSaBwpuiZj5Xxxi1N3M905vcDaBwPYLIyUZeIep7?=
 =?iso-8859-1?Q?cJSL7N3qlIsxmqMrD2EEtYMFbpEOLIg/Iw2kguLssxxT3HsAwJw6M=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?+jQ7ekweUz7LOuEnBkkgRvj/0wAi27qh6z4ukpig92AhPEYD4OO0mQvFe8?=
 =?iso-8859-1?Q?4/d3/NWbXDbzlSeWWxZEjRv8qmIgvutqKtbfF6kXiQt1wUG2Gsb+HHO/aj?=
 =?iso-8859-1?Q?fAFDSGWBB85jqIJ6B5A4sc6pwoIVqGCuZmSuEtt+zQQPd0aI2/NmqRodvK?=
 =?iso-8859-1?Q?1xH9zP87SfSO5s7/LLme9gcXkqmfMFXxUJMCo7pafdXPZITcK2l8IVejvU?=
 =?iso-8859-1?Q?Ib1eXr07XoM5wj04RFX5hty2jUcLCKZggJ9r1Rwv1ASiUXu/sfPqRnlbWZ?=
 =?iso-8859-1?Q?TA1kjowEMzI/E9BhnJTqd+SzrfgG1CDq+Um58iQQBUPgw7YmAMY6x0i/6S?=
 =?iso-8859-1?Q?DKrds+WGTcV0ByYFL5Wwq1RerADsR3dPFWgm+UOW6tR7d5t86dsuGFkZnp?=
 =?iso-8859-1?Q?shNg2wTW1kAULwfSm6ObW0SBzo5E9JgtP1UIB5xJTaQY0ym8pYyusMLaJO?=
 =?iso-8859-1?Q?RCYvRAl2XpSSkDB+KTdmSVwEw/4ZZzw69MIn80lF43OOKPHpmNWLrl2tef?=
 =?iso-8859-1?Q?vuejBzuOcwdZ1u2njCt5y2hHMb4NJaLACWAvE9Ya/LmMHDK+ULWegMi/8f?=
 =?iso-8859-1?Q?PDMah0fzmym50yaaLhPMLptE7v/3ZVLdR7HRahsif4pALDseF6EVTrQfC+?=
 =?iso-8859-1?Q?mGNdGnrGsbprnnCe63ehZf2n/r1saKqtvXBu9DEAD7XdFmaA1OHdFiOlik?=
 =?iso-8859-1?Q?WwhK53UhE03mD+JYWbxEIHihWEWiNhmPsP9dzJi+95XDin6hds7XL4RIw/?=
 =?iso-8859-1?Q?0vbSJQDv7HW6+0UvdR64qweqN7jmJgpQYJZm6iFzWqI5pivn3vP+716/Zx?=
 =?iso-8859-1?Q?b7F3yooJvZhqOtmB5y9fnQoEDvZ27B/DKmi0W2rY+2qwdbKFMn+Hvwt8YC?=
 =?iso-8859-1?Q?vTB0c0s4dmmGfeNyLasR1CMjwE6mpqEAHY+X3zLuTommQ0NfXVQZMB7jy7?=
 =?iso-8859-1?Q?KSVqc3dq8JkoeLQib00xg1hRwux6zhyzS4DjQY6B18xBHqzdo8eK5b/ovW?=
 =?iso-8859-1?Q?bvVsxv5/1jQdo+zZN/1wv6l3ewHufrZLBp51cU3PPpxEF+skbdPs5yGR3y?=
 =?iso-8859-1?Q?+FLLKhm4xoQxTxhM75+HhnYVgaA4w3fylxeKboAP7B8Ag8up70fLM7cM4u?=
 =?iso-8859-1?Q?bOe3NLrLkeX7TbEI8hutNhAjdEjdhi54wLy0m0wnrzA93T8UqVSc9ni4PU?=
 =?iso-8859-1?Q?+FclfZDGGBiLbGpmKm9RoipMZIzg5IjDzW/d7zRFEuQmEDa8Y5k4/Za5nQ?=
 =?iso-8859-1?Q?EWG3UWgELgBNKWyqPI6fRC9geFnkuxSIeg1aBdsbNlraNpcUpDlGpa4Cum?=
 =?iso-8859-1?Q?GT2rOpar8XEDlERA6qyV91AgUaLAa5UTTme82RUkZE9vPwDrBIBmKUghE9?=
 =?iso-8859-1?Q?we2V8sEbC28SjO2B+mn/PojxTGli9wij9VYRJCJD2hbKkS8NBoWyAYn1aZ?=
 =?iso-8859-1?Q?3yFvN5eKKbfVCy8LiNpK65VZcb4OA78MjkTb/9IKA09d5j+wCWgfJ+z9yg?=
 =?iso-8859-1?Q?xHRLmA/kCc/XlaimK2xoyYbq3LzI9d/sgLMZvv2Ur83MA5HpQkaOAUlHq8?=
 =?iso-8859-1?Q?jkqawVcJugmZYOm02ChIVHogFrpuPtqjH/LD6mBGoSve/YLfPjNXTPrsLr?=
 =?iso-8859-1?Q?+mwQ+pkVR+1u5xY04M5Ue+WRz8TJi3JyZKLLd6qK96x8HuvOh2DSzzKg?=
 =?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: 4b15d4ff-3069-47c2-aa35-08dcf8546174
X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Oct 2024 20:00:47.5624
 (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: hAHnvY+hkBX6j3RJEqBwuQPQ7K/JDoqCHYmwnSZDyywqazgXBbSxZoStCXbG7Iu0sgBdwe57NFDu+kqP6IfvcKe79SnFFpnnjc0rSXOg81cwDhSYzah1BiiEh8MEqSQK
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR0P278MB1351
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/GV0P278MB04192D0C51E525B5D6443691D24B2%40GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

>>Maybe check that "files" is the first mechanism for hosts lookups in nssw=
itch.conf.=0A=
=0A=
>afaik dig doesn't follow the same name resolution path as glibc.=0A=
=0A=
I don't know. Is there a way to test the glibc way easily?=0A=
=0A=
> a connection received=A0should mean resolution was done, right ? am i=A0m=
issing something?=0A=
=0A=
>Well, I'm just throwing out something to check, but I meant on the server,=
 not the client. It's trying to resolve >"localhost" to check the auth. If =
there's a delay, that's probably where it is.=0A=
=0A=
>I guess I just assumed that's where you were testing dig.=0A=
=0A=
Yes=0A=
=0A=
Regards=0A=
Daniel=