Re: problems with postgresql 10.1 hba_conf on fedora 27 - Mailing list pgsql-general

From David G. Johnston
Subject Re: problems with postgresql 10.1 hba_conf on fedora 27
Date
Msg-id CAKFQuwbpbt8T7DDiKSTMS6m6CcmxjemHAwk7K+0ML52UVZnP0A@mail.gmail.com
Whole thread Raw
In response to Re: problems with postgresql 10.1 hba_conf on fedora 27  (rob stone <floriparob@gmail.com>)
Responses Re: problems with postgresql 10.1 hba_conf on fedora 27
List pgsql-general
On Wednesday, December 20, 2017, rob stone <floriparob@gmail.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.

pgsql-general by date:

Previous
From: mark
Date:
Subject: Re:Re: postgresql 9.5 has ocuuered OOM
Next
From: support-tiger
Date:
Subject: Re: problems with postgresql 10.1 hba_conf on fedora 27