public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Abraham, Danny <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
Date: Wed, 9 Apr 2025 12:31:38 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <SA1PR02MB9698E33C149B9EA9D084CE048EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
References: <SA1PR02MB96986CA15EEF976BFE16D2F28EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
	<CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<SA1PR02MB9698C208DA8AA4A752DEDC988EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
	<SA1PR02MB9698E33C149B9EA9D084CE048EB42@SA1PR02MB9698.namprd02.prod.outlook.com>

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
[email protected]







view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox