Re: pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte
<folarte(at)peoplecall(dot)com> wrote:
> Hi Arnaud:
> On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury
> <arnaud(dot)gaboury(at)gmail(dot)com> wrote:
>> There is a public IP with a domain name (http works OK).
> Nice to know, but does not matter if all you use is 127.0.0.1
>
>
>> I entered this line in pg_hab.conf:
>
> Have you checked the filename? you are saying HAB, but it is HBA (
> Host Based Auth ) . May be a typo,

Yes it is.

but better safe then sorry. And
> have you checked it is stored in the right place?
>
>
>> ------------------------------
>> host mattermost mmuser 127.0.0.1 md5
>> --------------------------------------------------------
>
> Are this all the contents of you pg_hba.conf? Note order matters, all
> non comment ( or at least the host ones ) need to be checked .

Here is the whole content:
---------------------------------------------
75
76 # TYPE DATABASE USER ADDRESS METHOD OPTION
77
78 # "local" is for Unix domain socket connections only
79 local thetradinghall mailman peer
map=mailmap
80 local all postgres trust
81 #-------------------------------------------------------------------#
82
83 # IPv4 local connections:
84 host mattermost mmuser 127.0.0.1/24 md5
85 # IPv6 local connections:
86
87
88 #--------------------------------------------------------------------#
89

>
>
> Also, did you signal the postmaster to reread after adding the line?

What do you mean?
>
> Francisco Olarte.

--

google.com/+arnaudgabourygabx