On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > 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. The issue is solved (see my replies). By any chance, did you deploy on Fedora? There is no official package and I must build my own .rpm. > > 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. -- google.com/+arnaudgabourygabx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general