From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_hba.conf : bad entry for ADDRESS |
Date: | 2016-08-25 14:38:05 |
Message-ID: | 3823e032-1054-b104-2000-4bfc17396572@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2016-08-25 14:43:23 | Re: pg_hba.conf : bad entry for ADDRESS |
Previous Message | Ilya Kazakevich | 2016-08-25 14:37:31 | Re: pg_hba.conf : bad entry for ADDRESS |