Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses
Date
Msg-id 4852F2EF.2060901@dunslane.net
Whole thread Raw
In response to Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>   
>> Perhaps the solution to this problem is to do the lookups and store the
>> TTL of each answer.  At the time of actually checking you need only get
>> a new answer for those that expired.
>>     
>
> This is not behavior we'd want to put into the postmaster, though,
> and it's hard to see how to manage it otherwise.  (Well, maybe a new
> postmaster child process just for this, but I find it hard to believe
> the feature is worth that.)
>
>             
>   

Indeed.

The only circumstance in which this feature should be used is probably 
where you have control over the zones involved. For remote connections 
I'd far rather have an open address specification and require SSL with 
client side certs.

The potential for self-inflicted pain from this feature does worry me a bit.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses
Next
From: Kris Jurka
Date:
Subject: Re: Options for protocol level cursors