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 <hemilruparel2...@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.a...@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 >> >>
