Search Postgresql Archives

Re: pg_hba.conf : bad entry for ADDRESS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux