| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) |
| Date: | 2025-04-09 19:31:38 |
| Message-ID: | 7f56b879-d611-4e04-a116-e89fbeb88730@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-04-09 19:34:01 | Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) |
| Previous Message | Abraham, Danny | 2025-04-09 19:23:41 | FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) |