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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <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 18:03:30
Message-ID: 35c0f4a6-312d-436d-a761-934edfd48ac4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/29/24 10:42 AM, Daniel Westermann (DWE) wrote:
>> 1) host=xx.xx.xx.100 = localhost?
>
> No, it is not

Is the localhost machine on the same network?

Is the client connection string using IPV4 address or host name?

>
>> 2) In postgresql.conf what is listen_addresses set to?
>
> *
>
>> 3) What are the settings in /etc/hosts?
>
> Standard Ubuntu settings:
>
> 127.0.0.1 localhost
> 127.0.1.1 abc cde
>
> # The following lines are desirable for IPv6 capable hosts
> ::1 localhost ip6-localhost ip6-loopback
> ff02::1 ip6-allnodes
> ff02::2 ip6-allrouters

Contents of resolv.conf?

Would it be possible to crank the logging detail up?

>
> Regards
> Daniel

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2024-10-29 18:20:45 Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba
Previous Message Daniel Westermann (DWE) 2024-10-29 17:42:45 Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba