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 1t627u-00ACK9-1J for pgsql-general@arkaria.postgresql.org; Wed, 30 Oct 2024 06:24:18 +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 1t627r-005n5a-Ng for pgsql-general@arkaria.postgresql.org; Wed, 30 Oct 2024 06:24:16 +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 1t627r-005n5R-Ba for pgsql-general@lists.postgresql.org; Wed, 30 Oct 2024 06:24:15 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t627p-003lwX-6Q for pgsql-general@lists.postgresql.org; Wed, 30 Oct 2024 06:24:14 +0000 Received: by mail-ed1-x534.google.com with SMTP id 4fb4d7f45d1cf-5c9454f3bfaso7469079a12.2 for ; Tue, 29 Oct 2024 23:24:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec.at; t=1730269452; x=1730874252; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=DxPBsbFeFp7+Jzb1ocfewjWkL+Mav9LUkX45UFhE56o=; b=UwYF7jAMnTJj3etPGRkFwKFA0cfXEx2dNBjz+93rU11zV3W+tTM2M/DUQpix5eti5/ dN8tkEruVB3VJ1Hse+95R1M2TQsn1djqUYZzX1w7QuI16HGRYySaaLpg1x8brmfVjRUm BdcAH68Dxm/fhnpHUmTYWoWcgS28Aj3z3uDOM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730269452; x=1730874252; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=DxPBsbFeFp7+Jzb1ocfewjWkL+Mav9LUkX45UFhE56o=; b=OeuCgEBFpccLZri5A8D9Rber48E5Fb7Jw8l1pyARFEJBZZoFOEVbYTsi9YA/3RwxWU 6A5r9sDwkmwW5UD1I+ZA8aC0oCW7a8KsLSEcc66w0qVzz6MoT9mnQ9RJk97o/0PGukr3 PDtCX03FEtevhEPl90X2Opx6jTbvrrSIW0roZBo/owIBzAX8DgtZFis5Kw6ePudeu52x c1NK8iiRSJUHg/H6Q+VjIbDCAdCotA/HUZFTyxxGA4S3d73aou3GfNlyl3VOH1hsCISK XylKCm60PwwMbPsXjvwQSDy5v+Mvyt0XFA/ikbOKJZTCTcFu+fnK5w8cKnrmLseHBmxT VXfg== X-Forwarded-Encrypted: i=1; AJvYcCUGLxZD/jjRwF2GA3872Iv3nj7uTggmRPET5KiHioaFr36NiIRuRKEv/XVWmphVbs50SLwuiZpfGgOeUvXd@lists.postgresql.org X-Gm-Message-State: AOJu0Ywex5OjzkKfQbAxN4ih2I7ePA3u8QwVXCEuyOIbYWhZpoMnytWX d0fOAVcOpLaAs81tHwKtE5Ggg0pLEAWyQFAaRMEvwUjCE0l4kbAWKKWhPqmChM4= X-Google-Smtp-Source: AGHT+IEes3V3P+y6l4QKFVbvlrkTo+uf4w2eMCuw7ADDtKZ8du19wZyox4zvmZhs37H0MxnjZHWrVw== X-Received: by 2002:a05:6402:51cc:b0:5ca:c616:347d with SMTP id 4fb4d7f45d1cf-5cbbfab29acmr9562733a12.36.1730269451778; Tue, 29 Oct 2024 23:24:11 -0700 (PDT) Received: from localhost.localdomain ([213.235.133.41]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5cbb63475casm4478332a12.88.2024.10.29.23.24.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 29 Oct 2024 23:24:11 -0700 (PDT) Message-ID: <376cac6e4ffe1dfb9f59f47a9652dfa49c033ec6.camel@cybertec.at> Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba From: Laurenz Albe To: "Daniel Westermann (DWE)" , "pgsql-general@lists.postgresql.org" Date: Wed, 30 Oct 2024 07:24:06 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlLCAyMDI0LTEwLTI5IGF0IDE2OjMwICswMDAwLCBEYW5pZWwgV2VzdGVybWFubiAoRFdF KSB3cm90ZToKPiB3ZSdyZSBmYWNpbmcgYSBzdHJhbmdlIGlzc3VlIHdpdGggZGVsYXlzIGJldHdl ZW4gImNvbm5lY3Rpb24gcmVjZWl2ZWQiIGFuZCAiY29ubmVjdGlvbiBhdXRoZW50aWNhdGVkIi4K PiAKPiAjIHNlbGVjdCB2ZXJzaW9uKCk7Cj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgdmVyc2lvbgo+IC0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tCj4gwqBQb3N0Z3JlU1FMIDE1LjYgKFVidW50dSAxNS42LTEucGdkZzIyLjA0KzEpIG9u IHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDExLjQuMC0xdWJ1 bnR1MX4yMi4wNCkgMTEuNC4wLCA2NC1iaXQKPiAoMSBsaWduZSkKPiAKPiBJIGtub3csIHRoaXMg aXMgbm90IHRoZSBsYXRlc3QgbWlub3IgdmVyc2lvbi4KPiAKPiAjIFwhIGNhdCAvZXRjL29zLXJl bGVhc2UgfCBoZWFkIC0xCj4gUFJFVFRZX05BTUU9IlVidW50dSAyMi4wNC40IExUUyIKPiAKPiBX aGF0IHdlIHNlZSBpbiB0aGUgbG9nIGlzIHRoaXMgKGFyb3VuZCA0IHNlY29uZHMgZGVsYXkpOgo+ IAo+IDIwMjQtMDUtMDcgMTU6Mjk6NTAuMjQ0IENFU1QgWzM2OTkwOV0gTE9HOsKgIGNvbm5lY3Rp b24gcmVjZWl2ZWQ6IGhvc3Q9eHgueHgueHguMTAwIHBvcnQ9NDg0MzQKPiAyMDI0LTA1LTA3IDE1 OjI5OjU0LjUxOCBDRVNUIFszNjk5MDldIExPRzrCoCBjb25uZWN0aW9uIGF1dGhlbnRpY2F0ZWQ6 IGlkZW50aXR5PSJ4eHh4eHgiIG1ldGhvZD1tZDUgKC9ldGMvcG9zdGdyZXNxbC8xNS9tYWluL3Bn X2hiYS5jb25mOjEyMSkKPiAKPiBUaGUgbWF0Y2hpbmcgbGluZSBpcyB0aGlzICggSSBrbm93IG1k NSApOgo+IGhvc3TCoMKgwqAgYWxswqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHh4eHh4wqDCoMKg wqAgeHgueHgueHguMC8yNMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgbWQ1Cj4gCj4gV2hhdCB3ZSd2 ZSBmb3VuZCBvdXQgc28gZmFyIGlzLCB0aGF0IHRoaXMgb25seSBoYXBwZW5zIGlmIHdlIGhhdmUg YSBsb2NhbGhvc3Qob3IgYW55IG90aGVyIGhvc3RuYW1lKSBsaW5lIGJlZm9yZSB0aGUgbGluZSBt YXRjaGluZyBvdXIgY29ubmVjdGlvbiwgc29tZXRoaW5nIGxpa2UgdGhpczoKPiBob3N0wqDCoMKg IHJlcGxpY2F0aW9uwqDCoMKgwqAgeHh4eHjCoMKgwqDCoCBsb2NhbGhvc3TCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqAgbWQ1Cj4gaG9zdMKgwqDCoCBhbGzCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqAgeHh4eHjCoMKgwqDCoCB4eC54eC54eC4wLzI0wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBt ZDUKCkknZCAic3RyYWNlIiBzdWNoIGEgZGF0YWJhc2UgY29ubmVjdGlvbiB0byBzZWUgd2hlcmUg dGhlIHRpbWUgaXMgc3BlbnQuCgpZb3VycywKTGF1cmVueiBBbGJlCg==