Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Date
Msg-id CAM+6J943vEYUvwM87yg6ZKG6Y_hrek3Cy5CP2F6B9TY2X3U4sQ@mail.gmail.com
Whole thread Raw
In response to Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba  (Alan Hodgson <ahodgson@lists.simkin.ca>)
List pgsql-general

On Wed, 30 Oct 2024 at 00:40, Alan Hodgson <ahodgson@lists.simkin.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.

maybe disabling ipv6 completely resolves this  for the time being.



--
Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba