From: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_hba.conf : bad entry for ADDRESS |
Date: | 2016-08-25 14:18:39 |
Message-ID: | CAK1hC9vZKrzaGVDZ90qNcQX3xWA-Vf1nc5TngMy7gRCMR9BnhQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am deploying mattermost on my machine following their documentation[0].
My machine network settings:
----------------------------------
$ ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
group default qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: host0(at)if4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue
state UP group default qlen 1000
link/ether 0e:7f:c3:fb:25:b1 brd ff:ff:ff:ff:ff:ff link-netnsid 0
inet 192.168.1.94/24 brd 192.168.1.255 scope global host0
valid_lft forever preferred_lft forever
inet6 fe80::c7f:c3ff:fefb:25b1/64 scope link
valid_lft forever preferred_lft forever
--------------------------------------------------------------------
There is a public IP with a domain name (http works OK).
I entered this line in pg_hab.conf:
------------------------------
host mattermost mmuser 127.0.0.1 md5
--------------------------------------------------------
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
------------------------------------
What am I doing wrong?
Thank you for help
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Kazakevich | 2016-08-25 14:26:14 | Re: pg_hba.conf : bad entry for ADDRESS |
Previous Message | Tatsuki Kadomoto | 2016-08-25 12:48:37 | Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed |