Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) - Mailing list pgsql-general

From David G. Johnston
Subject Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Date
Msg-id CAKFQuwZTtwHfwKwnm+UV8hg1Fj6aV7HogpG1Uw78ZO=DkOOObA@mail.gmail.com
Whole thread Raw
In response to RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)  ("Abraham, Danny" <danny_abraham@bmc.com>)
Responses RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
List pgsql-general
On Wed, Apr 9, 2025, 12:21 Abraham, Danny <danny_abraham@bmc.com> 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.
Thanks
Danny

Suggests there are environment variables coming into play making non-default choices for you.  Namely, making you not use local as the connection method.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Next
From: "Abraham, Danny"
Date:
Subject: RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)