On Tue, Jan 30, 2018 at 07:56:40AM +0000, Meirav Rath wrote:
> <snip>
> host all all 0.0.0.0/0 scram-sha256
> <snip>
>
> Because I can’t restart the postgresql service, it crashes when this
> is the setup. User postgres is the superuser, by the way.
You need to make the difference between a crash and what seems to just
be an incorrect configuration which prevents your server to start. If
you look at the line above which I have taken from the pg_hba.conf you
have written in your last email, it is incorrect. "scram-sha256" is not
a correct HBA method. You need to use "scram-sha-256" instead.
I would advise to look at the documentation correctly first:
https://www.postgresql.org/docs/devel/static/auth-pg-hba-conf.html
--
Michael