Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
| От | David G. Johnston |
|---|---|
| Тема | Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) |
| Дата | |
| Msg-id | CAKFQuwZTtwHfwKwnm+UV8hg1Fj6aV7HogpG1Uw78ZO=DkOOObA@mail.gmail.com обсуждение исходный текст |
| Ответ на | RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) ("Abraham, Danny" <danny_abraham@bmc.com>) |
| Ответы |
RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it)
|
| Список | 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 по дате отправления: