When I try to connect to the database, the log says: > FATAL: password authentication failed for user "user" > DETAIL: Connection matched pg_hba.conf line 88: "host user password 0.0.0.0/0 scram-sha-256"
So I think the client is using scram-sha-256 On Fri, Nov 27, 2020 at 8:45 PM Hemil Ruparel <hemilruparel2...@gmail.com> wrote: > The database has been upgraded > > On Fri, Nov 27, 2020 at 8:41 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 11/27/20 7:01 AM, Hemil Ruparel wrote: >> > I don't quite get what you mean by upgrading to scram-sha256. I >> > installed postgres 13. I haven't upgraded anything yet. >> >> In postgresql.conf see what password_encryption has been set to. If it >> is 'scram-sha-256` then it has been upgraded. >> >> >> >> > >> > On Fri, Nov 27, 2020 at 8:06 PM Zwettler Markus (OIZ) >> > <markus.zwett...@zuerich.ch <mailto:markus.zwett...@zuerich.ch>> wrote: >> > >> > Did you correctly upgrade your whole environment to >> scram-sha-256?____ >> > >> > __ __ >> > >> > __ __ >> > >> > <quote> >> > To upgrade an existing installation from |md5|to |scram-sha-256|, >> > after having ensured that all client libraries in use are new enough >> > to support SCRAM, set |password_encryption = 'scram-sha-256'|in >> > |postgresql.conf|, make all users set new passwords, and change the >> > authentication method specifications in |pg_hba.conf|to >> > |scram-sha-256|.____ >> > >> > </quote>____ >> > >> > __ __ >> > >> > __ __ >> > >> > -Markus____ >> > >> > __ __ >> > >> > __ __ >> > >> > __ __ >> > >> > *Von:*Hemil Ruparel <hemilruparel2...@gmail.com >> > <mailto:hemilruparel2...@gmail.com>> >> > *Gesendet:* Freitag, 27. November 2020 09:38 >> > *An:* Laurenz Albe <laurenz.a...@cybertec.at >> > <mailto:laurenz.a...@cybertec.at>> >> > *Cc:* pgsql-generallists.postgresql.org >> > <http://pgsql-generallists.postgresql.org> >> > <pgsql-general@lists.postgresql.org >> > <mailto:pgsql-general@lists.postgresql.org>> >> > *Betreff:* Re: How to debug authentication issues in Postgres____ >> > >> > __ __ >> > >> > 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"____ >> > >> > __ __ >> > >> > 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 >> >
