Yes, I was following a previous bug I found on your site - pg_hba_file_rules: "scram-sha256" instead of
"scram-sha-256".
So I fixed it, now pg_hba.conf looks like this:
hostallall0.0.0.0/0scram-sha-256
hostallpostgres0.0.0.0/0trust
Postgresql service is running. However, I can't login with user postgres, with the following error message:
"The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the
client'sIP address or subnet, and that it is using an authentication scheme supported by the driver."
When trying DBeaver and with
" FATAL: password authentication failed for user "postgres""
When using PGadmin 4 version 2.1 flask version 0.12.2
-----Original Message-----
From: Daniel Gustafson [mailto:daniel.gustafson@gmail.com] On Behalf Of Daniel Gustafsson
Sent: Tuesday, January 30, 2018 10:03
To: Meirav Rath <meirav.rath@imperva.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>; Tomas Vondra <tomas.vondra@2ndquadrant.com>;
pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15035: scram-sha-256 blocks all logins
> On 30 Jan 2018, at 08:56, Meirav Rath <meirav.rath@imperva.com> wrote:
>
> Like this?
> host all all 0.0.0.0/0
scram-sha256
There is a typo in this authentication method, it should be scram-sha-256 (not the second dash between "sha" and
"256”).
> Because I can’t restart the postgresql service, it crashes when this is the setup….
Changing the above should allow the database to start up.
cheers ./daniel
-------------------------------------------
NOTICE:
This email and all attachments are confidential, may be proprietary, and may be privileged or otherwise protected from
disclosure.They are intended solely for the individual or entity to whom the email is addressed. However, mistakes
sometimeshappen in addressing emails. If you believe that you are not an intended recipient, please stop reading
immediately.Do not copy, forward, or rely on the contents in any way. Notify the sender and/or Imperva, Inc. by
telephoneat +1 (650) 832-6006 and then delete or destroy any copy of this email and its attachments. The sender
reservesand asserts all rights to confidentiality, as well as any privileges that may apply. Any disclosure, copying,
distributionor action taken or omitted to be taken by an unintended recipient in reliance on this message is prohibited
andmay be unlawful.
Please consider the environment before printing this email.