MIME-Version: 1.0
References: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <8ec9d0b8dac0e38075c9630f02ef25b088f290ec.camel@lists.simkin.ca>
 <CAM+6J95NCg6WNDjYyx42zjeocKXoPf7emci1zHCTboXGaE+WeQ@mail.gmail.com> <6e109baeabafa57970d7e8a9cdcb86abde8b14df.camel@lists.simkin.ca>
In-Reply-To: <6e109baeabafa57970d7e8a9cdcb86abde8b14df.camel@lists.simkin.ca>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Wed, 30 Oct 2024 00:47:37 +0530
Message-ID: <CAM+6J943vEYUvwM87yg6ZKG6Y_hrek3Cy5CP2F6B9TY2X3U4sQ@mail.gmail.com>
Subject: Re: Delays between "connection received" and "connection
 authenticated" because of localhost entries in hba
To: Alan Hodgson <ahodgson@lists.simkin.ca>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000da81bc0625a27048"
Archived-At: <https://www.postgresql.org/message-id/CAM%2B6J943vEYUvwM87yg6ZKG6Y_hrek3Cy5CP2F6B9TY2X3U4sQ%40mail.gmail.com>
Precedence: bulk

--000000000000da81bc0625a27048
Content-Type: text/plain; charset="UTF-8"

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.

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>

--000000000000da81bc0625a27048
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"=
gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 30 Oct 2024 at 0=
0:40, Alan Hodgson &lt;<a href=3D"mailto:ahodgson@lists.simkin.ca">ahodgson=
@lists.simkin.ca</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div class=3D"msg-8008454996400659478"><div><div>Well, I=
9;m just throwing out something to check, but I meant on the server, not th=
e client. It&#39;s trying to resolve &quot;localhost&quot; to check the aut=
h. If there&#39;s a delay, that&#39;s probably where it is.</div><div><br><=
/div><div>I guess I just assumed that&#39;s where you were testing dig.</di=
v><div><span></span></div></div>
</div></blockquote></div><div><br clear=3D"all"></div><div>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.</div><div><br></div><div>also, the 4-5s delay is eerie=C2=
=A0similar to issues in the past.</div><div><br></div><div><a href=3D"https=
://unix.stackexchange.com/questions/290987/resolving-hostname-takes-5-secon=
ds">https://unix.stackexchange.com/questions/290987/resolving-hostname-take=
s-5-seconds</a></div><div>maybe disabling ipv6 completely resolves this=C2=
=A0 for the time being.</div><div><br></div><div></div><div><br></div><div>=
<br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"=
ltr" class=3D"gmail_signature"><div dir=3D"ltr">Thanks,<div>Vijay</div><div=
><br></div><div>Open to work</div><div>Resume -=C2=A0<a href=3D"https://git=
hub.com/cabecada" target=3D"_blank">Vijaykumar Jain</a><br></div></div></di=
v></div></div>

--000000000000da81bc0625a27048--