Re: pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte
<folarte@peoplecall.com> wrote:
> Hi Arnaud:
> On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury
> <arnaud.gaboury@gmail.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