Re: pg_hba.conf : bad entry for ADDRESS - Mailing list pgsql-general

From Francisco Olarte
Subject Re: pg_hba.conf : bad entry for ADDRESS
Date
Msg-id CA+bJJbzgjQg=x53UQpJczbvc84rPEaT3x1gpFYjcGg5Ai6c+YA@mail.gmail.com
Whole thread Raw
In response to pg_hba.conf : bad entry for ADDRESS  (arnaud gaboury <arnaud.gaboury@gmail.com>)
Responses Re: pg_hba.conf : bad entry for ADDRESS  (arnaud gaboury <arnaud.gaboury@gmail.com>)
List pgsql-general
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, 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 .


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

Francisco Olarte.


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS
Next
From: arnaud gaboury
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS