I commented out scram-sha-256 lines for IPv4 and IPv6. I still got authentication failure. The log output now says: FATAL: password authentication failed for user "centos" DETAIL: Connection matched pg_hba.conf line 89: "host database user 0.0.0.0/0 md5"
On Sat, Nov 28, 2020 at 7:34 PM Hemil Ruparel <hemilruparel2...@gmail.com> wrote: > Yes. Password encryption is set to scram-sha-256. > > On Fri, Nov 27, 2020 at 10:36 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 11/27/20 12:37 AM, Hemil Ruparel wrote: >> > 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 <http://0.0.0.0/0> scram-sha-256" >> >> To me that looks like a strange line for pg_hba.conf and I don't see it >> in the pg_hba.conf file you sent earlier. >> >> What is line 88 in your pg_hba.conf? >> >> > >> > 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 <mailto:hemilruparel2...@gmail.com>> wrote: >> > >> > Sorry. This was the replication section: >> > local replication all peer >> > host replication all 127.0.0.1/32 <http://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 <mailto: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 <http://127.0.0.1/32> >> > trust >> > host replication all ::1/128 >> > trust >> > >> > Yours, >> > Laurenz Albe >> > -- >> > Cybertec | https://www.cybertec-postgresql.com >> > <https://www.cybertec-postgresql.com> >> > >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >
