Re: How to debug authentication issues in Postgres

Поиск
Список
Период
Сортировка
От Hemil Ruparel
Тема Re: How to debug authentication issues in Postgres
Дата
Msg-id CANW1aT-Oj11RQUj62UQxzde6ziUpQjpv3JJgr__F4t48RZ6mMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to debug authentication issues in Postgres  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Ответы AW: How to debug authentication issues in Postgres  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Re: How to debug authentication issues in Postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
The log says:
> FATAL:  password authentication failed for user "centos"
> DETAIL:  Connection matched pg_hba.conf line 88: "host    user       password          0.0.0.0/0               scram-sha-256"

I can't understand where is the problem as both psql and pgadmin connect without problems using the same password

On Fri, Nov 27, 2020 at 1:46 PM Hemil Ruparel <hemilruparel2002@gmail.com> wrote:
Sorry. This was the replication section:
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

On Fri, Nov 27, 2020 at 1:41 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2020-11-27 at 13:34 +0530, Hemil Ruparel wrote:
> I have restarted postgres quite a few times to try making configuration changes and it
>  is always back up. I don't know how. Feels weird to me. I didn't add the line
>  "local replication all". It was there by default

I don't believe that.

This is how it looks by default:

# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Hemil Ruparel
Дата:
Сообщение: Re: How to debug authentication issues in Postgres
Следующее
От: pabloa98
Дата:
Сообщение: Re: postgres_fdw insert extremely slow