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 1t69bc-00B0bf-Bb for pgsql-general@arkaria.postgresql.org; Wed, 30 Oct 2024 14:23:28 +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 1t69bZ-009IxA-GX for pgsql-general@arkaria.postgresql.org; Wed, 30 Oct 2024 14:23:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t69bZ-009Iwt-5l for pgsql-general@lists.postgresql.org; Wed, 30 Oct 2024 14:23:25 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t69bW-003dLp-FK for pgsql-general@lists.postgresql.org; Wed, 30 Oct 2024 14:23:24 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-2fb3da341c9so66693621fa.2 for ; Wed, 30 Oct 2024 07:23:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730298201; x=1730903001; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=YNBgfm8rmGaO4g5EXqbXoSRjj+1AgdMuv5W7XDJ+3RI=; b=YZ/pAennHbKTrXKzxs/sRE2INb9cYOsJZ1MsPoTerGT71kINPZtg/EGNFXc63qWHI7 fdXd7q4TyOgPMv8/Cq67wcQvtxWJ6a69howtPxtnNBOVX8H3D0YG5yz5+2DSdl1uDuay Fr80BMYwN56MBOW6ceRCnOgms9fm5VGe7ZCOSl9Eyj2Qm/HJ9soWRQuKefJiCTFOP0ui ZfMmIdRYgA9yBGvfsmaGDYFiO9v6TbxYixZQPaqQsk0Ds+y++jejaBLcugQ1rM6zGnJz hDW2xC6ZhAGk4AjDtzxJ5bqCHFLhyuy0SZKXAdS18Uv4WqVrlXU0KtymSnp7o9NWRFny oIBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730298201; x=1730903001; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=YNBgfm8rmGaO4g5EXqbXoSRjj+1AgdMuv5W7XDJ+3RI=; b=nRpgmBrrrIURQwB/Q/dEVpbVpMFMQeIgbCuhfnR3CC6SWbTh5AxLJrENO9GgjMYqOZ ZGEXq2iRrIivt89jxmb1mb1tyXFc423Be3/qbgMzAhfFQ3K83vOvJ7uaSYpQ1AdGyZoR lORvGl5Kgr3zwgOwtpTfO2aFbtRpFQ1NDqirXHmRsraiE0i1Weg8OLzL+wJ7LGB1plSQ gVZzvIzr8fnWExm6boK+/yrTzt1u1uAASfMveRphZJsdjtoSoDbM37xwG3CFTX7HTo5/ 9UwvuuPRVM+ly4uLXAzmPP3P4ZHqkK58W/njftscGY4d1D5sGfd8h/fTwaRX6qQzz45H cW8A== X-Forwarded-Encrypted: i=1; AJvYcCUDxQPQfwnnWBeQcDTFwRBeM51AARHPrA9ess2E0iMm3noZd1q/ciNtNodN3o7CbmmE3pO6OR2H/+AMQtW1@lists.postgresql.org X-Gm-Message-State: AOJu0Yza65Wq0SkbhcY7ue3FjBBFg40bMgsaXuWqRwYBY7iTcqxnAnWw rrEk1fS3CtsFPRf1QDtW/LsMhmOTEgIdbXaRy09+Iuwn7P9FjmPqlQ3wI0mzeAwztrGHfebIyWJ ORwBrYGHhzeobLM4455nivwadQ7o= X-Google-Smtp-Source: AGHT+IGwoXrS6NAeR2rvx7qs1mI0zg5aocx+lwGOZB4JcweWR2U0FClET9ujLExUxT2Lg8stopMahBCr6RCpwZWhdXo= X-Received: by 2002:a2e:9b42:0:b0:2fb:597e:28d9 with SMTP id 38308e7fff4ca-2fcbdfbecbcmr63642321fa.14.1730298200175; Wed, 30 Oct 2024 07:23:20 -0700 (PDT) MIME-Version: 1.0 References: <376cac6e4ffe1dfb9f59f47a9652dfa49c033ec6.camel@cybertec.at> In-Reply-To: From: Greg Sabino Mullane Date: Wed, 30 Oct 2024 10:22:42 -0400 Message-ID: Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba To: "Daniel Westermann (DWE)" Cc: Laurenz Albe , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000093c0f00625b27185" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000093c0f00625b27185 Content-Type: text/plain; charset="UTF-8" I'd echo the suggestion to strace this. You can use the pre_auth_delay setting to help facilitate that. See: https://www.postgresql.org/docs/current/runtime-config-developer.html Cheers, Greg --00000000000093c0f00625b27185 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I'd echo the suggestion to strace this. You can use th= e pre_auth_delay setting to help facilitate=C2=A0that. See:

<= div>https://www.postgresql.org/docs/current/runtime-config-developer= .html

Cheers,
Greg

--00000000000093c0f00625b27185--