Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: "Abraham, Danny" <danny_abraham@bmc.com>

Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Francisco Olarte <folarte@peoplecall.com>, pgsql-general@lists.postgresql.org

Date: 2025-04-09T19:34:01Z

Lists: 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.