Feedback-ID: i76984098:Fastmail
Message-ID: <22ef7e8b-d03f-4626-95b0-0692478f9ac9@aklaver.com>
Date: Wed, 9 Apr 2025 13:59:40 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
To: "Abraham, Danny" <danny_abraham@bmc.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
 Francisco Olarte <folarte@peoplecall.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <SA1PR02MB96986CA15EEF976BFE16D2F28EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
 <CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
 <cc2290e0-4fdd-465c-a282-efd5101d2f1b@bmc.com>
 <8e9d16f4-9a8d-4917-9320-d48c7996e4d1@aklaver.com>
 <SA1PR02MB9698C208DA8AA4A752DEDC988EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
 <CAKFQuwZTtwHfwKwnm+UV8hg1Fj6aV7HogpG1Uw78ZO=DkOOObA@mail.gmail.com>
 <SA1PR02MB9698711388AFA3FE147BBF278EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <SA1PR02MB9698711388AFA3FE147BBF278EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/22ef7e8b-d03f-4626-95b0-0692478f9ac9%40aklaver.com>
Precedence: bulk

On 4/9/25 13:40, Abraham, Danny wrote:
> Thanks again.

>  4. I am not aware of an env variable that changes the top down matching
>     on pg_hba.conf

Should have added to previous post:

 From here:

https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

a) Set log_connections and log_disconnections to on if they are not 
already and reload the server conf.

b) Then look at Postgres log to see what the connection settings are for 
the connections in question.

> 
> Danny
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com