From: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
---|---|
To: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_hba.conf : bad entry for ADDRESS |
Date: | 2016-08-25 14:35:03 |
Message-ID: | CAK1hC9uXmhb59Dsedwyq2u6RDF3Qf3s+_yHnxNesAm4ksSOQvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
--
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2016-08-25 14:36:56 | Re: pg_hba.conf : bad entry for ADDRESS |
Previous Message | Ilya Kazakevich | 2016-08-25 14:34:46 | Re: pg_hba.conf : bad entry for ADDRESS |