Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses

Bruce Momjian wrote:
> Dickson S. Guedes wrote:
>   
>> Hi all,
>>
>> There is a TODO Item to allow pg_hba.conf to specify host names along
>> with IP addresses.
>>
>> I'd like to work on this feature, if nobody is working too and no
>> objection exists.
>>     
>
> Please do --- I know of no one working on that.
>   

The reason it wasn't done years ago was that there was disagreement on 
the way it should work. And the TODO actually lists several alternatives:
   Host name lookup could occur when the postmaster reads the   pg_hba.conf file, or when the backend starts. Another
solutionwould   be to reverse lookup the connection IP and check that hostname   against the host names in pg_hba.conf.
Wecould also then check that   the host name maps to the IP address.
 


So before you start actually working on it, let's see if we have a 
better level of agreement on what it should do. Personally, I favor 
hostname lookup on backend start but none of the others.

cheers

andrew