Feedback-ID: i76984098:Fastmail
Message-ID: <7f56b879-d611-4e04-a116-e89fbeb88730@aklaver.com>
Date: Wed, 9 Apr 2025 12:31:38 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
To: "Abraham, Danny" <danny_abraham@bmc.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>
 <SA1PR02MB9698E33C149B9EA9D084CE048EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <SA1PR02MB9698E33C149B9EA9D084CE048EB42@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/7f56b879-d611-4e04-a116-e89fbeb88730%40aklaver.com>
Precedence: bulk

On 4/9/25 12:23, Abraham, Danny wrote:
> Thanks again.
> Here is the example:
>>>>>>>>>
> dba-tlv-x6y64k% cat pg_hba.conf
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> local   all         all                               trust
> host    all         all         0.0.0.0/0                   scram-sha-256
> 
> dba-tlv-x6y64k% pg_ctl reload
> server signaled
> dba-tlv-x6y64k% psql -Upostgres
> Password for user postgres:
> psql (17.4)
> Type "help" for help.
> 
> ctrlmdb=#
>>>>>>>>
> PSQL should not have asked for the password.

Do you have more then one instance of Postgres running on this machine?

If so are you editing the correct pg_hba.conf?

How did you install Postgres and what Linux distro(& version) are you using?


> Thanks
> Danny
> 
>
-- 
Adrian Klaver
adrian.klaver@aklaver.com