Re: host name support in pg_hba.conf - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: host name support in pg_hba.conf
Date
Msg-id 1281418176.24957.6.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: host name support in pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On mån, 2010-08-09 at 15:25 -0400, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Here is a patch for host name support in pg_hba.conf.
> 
> My recollection is that the previous discussions got stuck on the cost
> of doing DNS lookups for every connect; and the obvious solution of
> trying to cache the names was shot down on the basis of not knowing when
> to flush the cache.  Have you decided that people who want this feature
> will just have to pay that cost?

Either that or install nscd.

While the speed of establishing a connection is critical to some setups,
there are also plenty of setups where the connection setup speed is
pretty much unimportant because of connection pooling.

> If so, I think the documentation needs
> to be a bit more explicit about names being more expensive than IP
> addresses in pg_hba.conf.

Fair enough.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: host name support in pg_hba.conf
Next
From: Bruce Momjian
Date:
Subject: Re: TODO 9.0 done items removed