Re: pg_hba.conf : bad entry for ADDRESS

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: arnaud gaboury <arnaud(dot)gaboury(at)gmail(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:29:03
Message-ID: CA+bJJbzgjQg=x53UQpJczbvc84rPEaT3x1gpFYjcGg5Ai6c+YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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, 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message arnaud gaboury 2016-08-25 14:31:55 Re: pg_hba.conf : bad entry for ADDRESS
Previous Message arnaud gaboury 2016-08-25 14:28:16 Re: pg_hba.conf : bad entry for ADDRESS