public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Daniel Westermann (DWE) <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Date: Tue, 29 Oct 2024 09:38:05 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
On 10/29/24 09:30, Daniel Westermann (DWE) wrote:
> Delays between "connection received" and "connection authenticated" because of localhost entries in hba
>
> Hi,
>
> we're facing a strange issue with delays between "connection received" and "connection authenticated".
>
> # select version();
> version
> -----------------------------------------------------------------------------------------------------------------------------------
> PostgreSQL 15.6 (Ubuntu 15.6-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
> (1 ligne)
>
> I know, this is not the latest minor version.
>
> # \! cat /etc/os-release | head -1
> PRETTY_NAME="Ubuntu 22.04.4 LTS"
>
> What we see in the log is this (around 4 seconds delay):
>
> 2024-05-07 15:29:50.244 CEST [369909] LOG: connection received: host=xx.xx.xx.100 port=48434
> 2024-05-07 15:29:54.518 CEST [369909] LOG: connection authenticated: identity="xxxxxx" method=md5 (/etc/postgresql/15/main/pg_hba.conf:121)
1) host=xx.xx.xx.100 = localhost?
2) In postgresql.conf what is listen_addresses set to?
3) What are the settings in /etc/hosts?
>
> The matching line is this ( I know md5 ):
> host all xxxxx xx.xx.xx.0/24 md5
>
> What we've found out so far is, that this only happens if we have a localhost(or any other hostname) line before the line matching our connection, something like this:
> host replication xxxxx localhost md5
> host all xxxxx xx.xx.xx.0/24 md5
>
> We don't see it if we do it like this:
> host all xxxxx xx.xx.xx.0/24 md5
> host replication xxxxx localhost md5
>
> Has anyone experienced such a behavior? It seems clear that this is somehow related to name resolution but we couldn't reproduce something like this on the OS using dig (in a loop several hundred of times). It is also only happening from time to time, and not constantly.
>
> What we're basically looking for is a way to prove the assumption without involving PostgreSQL at all, if that does make sense?
>
> Many thanks in advance
> Daniel
>
>
--
Adrian Klaver
[email protected]
view thread (3+ messages) latest in thread
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]
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
In-Reply-To: <[email protected]>
* 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