From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | rob stone <floriparob(at)gmail(dot)com> |
Cc: | support-tiger <support(at)tigernassau(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: problems with postgresql 10.1 hba_conf on fedora 27 |
Date: | 2017-12-21 01:33:22 |
Message-ID: | CAKFQuwbpbt8T7DDiKSTMS6m6CcmxjemHAwk7K+0ML52UVZnP0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday, December 20, 2017, rob stone <floriparob(at)gmail(dot)com> wrote:
>
> > local all all postgres peer
> >
> > host all all 127.0.0.1/32 md5
> >
> > host all all ::1/128 md5
> >
> > now gives error on restart and we cannot find the log file
> >
>
> "local" is for socket connections, yet you have an address of
> "postgres". How did this function in the past?
>
>
Sorta, but correct enough. Local lines and host lines have differing
numbers of columns. As written the auth-method is "Postgres" with
auth-option of "md5" (i.e., there is no address column for local) which is
simply wrong. Whether it's an email typo or the actual file...
I suspect it's possible we used to ignore malformed lines whereas now we
error...
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | support-tiger | 2017-12-21 03:30:21 | Re: problems with postgresql 10.1 hba_conf on fedora 27 |
Previous Message | mark | 2017-12-21 00:37:43 | Re:Re: postgresql 9.5 has ocuuered OOM |