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 -----Original Message----- From: Adrian Klaver <adrian.kla...@aklaver.com> Sent: Wednesday, April 9, 2025 8:49 PM To: Abraham, Danny <danny_abra...@bmc.com>; Francisco Olarte <fola...@peoplecall.com> Cc: pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) On 4/9/25 10:45 AM, Abraham, Danny wrote: > Failure eans going down the hba list and asking for the password. In pg_hba.conf first match wins, sounds like you have password auth line before the trust lines. You need to provide the complete pg_hba.conf auth lines you are working with. > > > Sent from Workspace ONE Boxer > > On Apr 9, 2025 20:04, Francisco Olarte <fola...@peoplecall.com> wrote: > On Wed, 9 Apr 2025 at 18:20, Abraham, Danny <danny_abra...@bmc.com> wrote: >> Asking for help with inability to connect local using trust Fail >> #local all all trust #local >> all dbauser peer OK #host all all >> 127.0.0.1/32 trust > > How are you connecting? Your symptoms matches confusing local with > TCP/IP to localhost. They are not the same thing. > Also, are you on windows? ( which does not have unix sockets ). > > local > This record matches connection attempts using Unix-domain sockets. > Without a record of this type, Unix-domain socket connections are > disallowed. > host > This record matches connection attempts made using TCP/IP. host > records match SSL or non-SSL connection attempts as well as GSSAPI > encrypted or non-GSSAPI encrypted connection attempts. > > On a unix host psql -h localhost will use the host line, psql -h > /socket/path will go to the local one, and no -h defaults to socket. > On a windows host it default to tcp/ip to localhost. > > Francisco Olarte. -- Adrian Klaver adrian.kla...@aklaver.com
