Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Francisco Olarte
Hi Arnaud: On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury wrote: >> Are this all the contents of you pg_hba.conf? Note order matters, all >> non comment ( or at least the host ones ) need to be checked . > Here is the whole content: > 79 local thetradinghall mailman

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Francisco Olarte
On Thu, Aug 25, 2016 at 4:28 PM, arnaud gaboury wrote: > On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich > wrote: >>>I entered this line in pg_hab.conf: >> Are you sure your file name is correct and it is really used by postgres? > I think so as another service (Postfix) is running and working.

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 5:50 PM, Francisco Olarte wrote: > Hi Arnaud: > > On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury > wrote: >>> Are this all the contents of you pg_hba.conf? Note order matters, all >>> non comment ( or at least the host ones ) need to be checked . >> Here is the whole cont

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 5:43 PM, Francisco Olarte wrote: > On Thu, Aug 25, 2016 at 4:28 PM, arnaud gaboury > wrote: >> On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich >> wrote: I entered this line in pg_hab.conf: >>> Are you sure your file name is correct and it is really used by postgres?

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 5:26 PM, Joshua D. Drake wrote: > On 08/25/2016 07:44 AM, arnaud gaboury wrote: >> >> On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake >> wrote: > > >>> Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the >>> pg_hba.conf. >>> >>> FTR: I have deployed M

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Joshua D. Drake
On 08/25/2016 07:44 AM, arnaud gaboury wrote: On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake wrote: 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

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Ilya Kazakevich
% psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser psql: could not translate host name "127.0.0.1/32" to address: Name or service not known % psql --host=127.0.0.1/24 --dbname=mat

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:27 PM, Melvin Davidson wrote: > > > On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury > wrote: > >> I am deploying mattermost on my machine following their documentation[0]. >> >> My machine network settings: >> -- >> $ ip a >> 1: lo: mtu

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Joshua D. Drake
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 matte

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake 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

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:37 PM, Ilya Kazakevich wrote: > > % psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser > psql: could not translate host name "127.0.0.1/32" to address: Name or > service not known > % psql --host=127.0.0.1/24 --dbname=mattermost --username=mmuser > psql: could

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte wrote: > Hi Arnaud: > On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury > wrote: >> There is a public IP with a domain name (http works OK). > Nice to know, but does not matter if all you use is 127.0.0.1 > > >> I entered this line in pg_hab.conf: >

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:32 PM, Tom Lane wrote: > arnaud gaboury writes: >> I entered this line in pg_hab.conf: >> -- >> host mattermost mmuser 127.0.0.1 md5 > >> What am I doing wrong? > > Looking in the postmaster log for complaints about pg_

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Melvin Davidson
On Thu, Aug 25, 2016 at 10:28 AM, arnaud gaboury wrote: > On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich > wrote: > >>I entered this line in pg_hab.conf: > > Are you sure your file name is correct and it is really used by postgres? > > I think so as another service (Postfix) is running and wor

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Ilya Kazakevich
>How can I verify ? Can you connect as postgres (superuser)? If yes, connect and type "show hba_file;" If no, try adding "local all postgres peer" or even "local all postgres trust" to this file and restart postgres. Check again. -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Tom Lane
arnaud gaboury writes: > I entered this line in pg_hab.conf: > -- > host mattermost mmuser 127.0.0.1 md5 > What am I doing wrong? Looking in the postmaster log for complaints about pg_hba.conf would probably have helped you diagnose this. But

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Francisco Olarte
Hi Arnaud: On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury wrote: > There is a public IP with a domain name (http works OK). Nice to know, but does not matter if all you use is 127.0.0.1 > I entered this line in pg_hab.conf: Have you checked the filename? you are saying HAB, but it is HBA ( Hos

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Melvin Davidson
On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury wrote: > I am deploying mattermost on my machine following their documentation[0]. > > My machine network settings: > -- > $ ip a > 1: lo: mtu 65536 qdisc noqueue state UNKNOWN > group default qlen 1 > link/loop

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich wrote: >>I entered this line in pg_hab.conf: > Are you sure your file name is correct and it is really used by postgres? I think so as another service (Postfix) is running and working. How can I verify ? > > > Ilya Kazakevich > > JetBrains > http:

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread Ilya Kazakevich
>I entered this line in pg_hab.conf: Are you sure your file name is correct and it is really used by postgres? Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] pg_hba.conf : bad entry for ADDRESS

2016-08-25 Thread arnaud gaboury
I am deploying mattermost on my machine following their documentation[0]. My machine network settings: -- $ ip a 1: lo: 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 h