public inbox for [email protected]  

help / color / mirror / Atom feed
From: Daniel Westermann (DWE) <[email protected]>
To: Tom Lane <[email protected]>
To: Greg Sabino Mullane <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Date: Wed, 30 Oct 2024 15:07:32 +0000
Message-ID: <GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <[email protected]>
References: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
	<[email protected]>
	<GV0P278MB04198D3BBE5F475C75D34C74D2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
	<CAKAnmmKJ5PP4W=xDLsddoCUVGexOr_EVAG--jH7KGC-FBOB1Zg@mail.gmail.com>
	<[email protected]>

>>Greg Sabino Mullane <[email protected]> writes:
>> I'd echo the suggestion to strace this. You can use the pre_auth_delay
>> setting to help facilitate that. See:

>IIUC, the delays are rare and unpredictable, so that strace'ing seems
>unlikely to be practical.

>If rebuilding from source is feasible, you could insert monitoring
>elog(LOG) calls around the name lookup (that is, around the
>pg_getnameinfo_all call in src/backend/libpq/hba.c).  This would
>confirm or disprove the theory that the name lookup is the source
>of the issue, which is about as much as we'd get out of strace.

Thanks for all your tips/hints

Regards
Daniel





view thread (3+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
  In-Reply-To: <GV0P278MB041983236163E8B0755D089BD2542@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox