Feedback-ID: i76984098:Fastmail
Message-ID: <35c0f4a6-312d-436d-a761-934edfd48ac4@aklaver.com>
Date: Tue, 29 Oct 2024 11:03:30 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Delays between "connection received" and "connection
 authenticated" because of localhost entries in hba
To: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <GV0P278MB0419EB5885DF99C5354804A9D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <792f687d-5188-4beb-b94b-3d3edeb384a3@aklaver.com>
 <GV0P278MB0419206FD180B746F01413F8D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <GV0P278MB0419206FD180B746F01413F8D24B2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/35c0f4a6-312d-436d-a761-934edfd48ac4%40aklaver.com>
Precedence: bulk


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.klaver@aklaver.com