Re: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should - Mailing list pgsql-bugs

From Tudor Barascu
Subject Re: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should
Date
Msg-id 1369816639.184.YahooMailNeo@web120906.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Hi and thank you for replying.=0A=0AI have tried using the FQDN without suc=
cess.=0A=0AThe reverse DNS server was already setup.=0AAfter installing=A0=
=A0bridge-utils in order to run the host command and I discovered the rever=
se dns had config problems=0A(something you suggested)=0A=0A$host laptop=0A=
=0Alaptop.biroul.gis has address 192.168.111.6=0A=0A$host 192.168.111.6=0AH=
ost 6.111.168.192.in-addr.arpa. not found: 3(NXDOMAIN)=0A=0AI have fixed th=
e reverse DNS configuration and now all is alright.=0A=0AThank you,=0ATudor=
=A0=0A=0A=0A________________________________=0A From: Peter Eisentraut <pet=
er_e@gmx.net>=0ASent: Tuesday, May 28, 2013 4:03 PM=0ASubject: Re: [BUGS] B=
UG #8172: entering the hostname in the address column in pg_hba.conf doesn'=
t work as it should=0A =0A=0AOn 5/21/13 3:41 AM, tudorbarascu@yahoo.com wro=
te:=0A> In pg_hba.conf I have the following setup:=0A> host=A0 =A0 all=A0 =
=A0  all=A0 =A0  laptop=A0 =A0 =A0 =A0 =A0 md5=0A> =0A> Although the hostna=
me gets resolved by the system (LAN DNS server) I still=0A> get the no pg_h=
ba.conf entry error.=0A=0ACheck that the following works:=0A=0A$ host lapto=
p=0A$ host x.x.x.x=0A=0Awhere x.x.x.x is the IP address that the first comm=
and printed.=A0 Those=0Aneed to match.=0A=0AI suspect that you need to writ=
e a fully-qualified domain name in=0Apg_hba.conf, and you need to set up th=
e reverse DNS.

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: bug in Prepared statement with DELETE RETURNING and rule on view
Next
From: Khamphousone Bounkong
Date:
Subject: Re: BUG #8183: field timestamp result to date