Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Date: 2024-10-29 19:17:37
Message-ID: CAM+6J943vEYUvwM87yg6ZKG6Y_hrek3Cy5CP2F6B9TY2X3U4sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 30 Oct 2024 at 00:40, Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca> wrote:

> 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.
>
> I guess I just assumed that's where you were testing dig.
>

Yep. my mistake. i did not read it correctly. in order to discard the rule,
it first has to find out by expanding the hosts in the rule, so yep, dns
resolution might be the problem.

also, the 4-5s delay is eerie similar to issues in the past.

https://unix.stackexchange.com/questions/290987/resolving-hostname-takes-5-seconds
maybe disabling ipv6 completely resolves this for the time being.

--
Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2024-10-29 19:55:50 Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Previous Message Alan Hodgson 2024-10-29 19:10:07 Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba