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"
> 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@xxxxxxxxx> 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-256On Fri, Nov 27, 2020 at 1:41 PM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
