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

From Joshua D. Drake
Subject Re: pg_hba.conf : bad entry for ADDRESS
Date
Msg-id 3823e032-1054-b104-2000-4bfc17396572@commandprompt.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
On 08/25/2016 07:18 AM, arnaud gaboury wrote:
> I am deploying mattermost on my machine following their documentation[0].

> There is a public IP with a domain name (http works OK).
>
> I entered this line in pg_hab.conf:

I assume you mean pg_hba.conf

> ------------------------------
>  host     mattermost         mmuser      127.0.0.1       md5
> --------------------------------------------------------
>

Make sure that is the *only* line referencing 127.0.0.1.


> Now when testing:
> --------------------------------------
> % psql --host=127.0.0.1 --dbname=mattermost --username=mmuser --password
> Password for user mmuser:
> psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user
> "mmuser", database "mattermost", SSL off
> ------------------------------------

Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the
pg_hba.conf.

FTR: I have deployed Mattermost and it works wonderfully.

JD



--
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.


pgsql-general by date:

Previous
From: "Ilya Kazakevich"
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS
Next
From: arnaud gaboury
Date:
Subject: Re: pg_hba.conf : bad entry for ADDRESS