On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte
<folarte@xxxxxxxxxxxxxx> wrote:
> Hi Arnaud:
> On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury
> <arnaud.gaboury@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
