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

Hi and thank you for replying.

I have tried using the FQDN without success.

The reverse DNS server was already setup.
After installing  bridge-utils in order to run the host command and I discovered the reverse dns had config problems
(something you suggested)

$host laptop

laptop.biroul.gis has address 192.168.111.6

$host 192.168.111.6
Host 6.111.168.192.in-addr.arpa. not found: 3(NXDOMAIN)

I have fixed the reverse DNS configuration and now all is alright.

Thank you,
Tudor 

________________________________
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
Sent: Tuesday, May 28, 2013 4:03 PM
Subject: Re: [BUGS] BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should

On 5/21/13 3:41 AM, tudorbarascu(at)yahoo(dot)com wrote:
> In pg_hba.conf I have the following setup:
> host    all    all    laptop          md5
>
> Although the hostname gets resolved by the system (LAN DNS server) I still
> get the no pg_hba.conf entry error.

Check that the following works:

$ host laptop
$ host x.x.x.x

where x.x.x.x is the IP address that the first command printed.  Those
need to match.

I suspect that you need to write a fully-qualified domain name in
pg_hba.conf, and you need to set up the reverse DNS.