Skip site navigation (1) Skip section navigation (2)

Re: Why don't we allow DNS names in pg_hba.conf?

From: elein <elein(at)varlena(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Why don't we allow DNS names in pg_hba.conf?
Date: 2006-01-02 03:36:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I also support this change.  My clients have tended to move
machines and networks around a lot as well as move databases from machine
to machine.  It would be nice to let the network gurus concentrate
on getting the dns servers up and correct and leverage that
work instead of having to change pg_hba.conf when these changes


On Sun, Jan 01, 2006 at 01:30:46PM -0500, Tom Lane wrote:
> I was reminded of $subject by
> While I haven't tried it, I suspect that allowing a DNS host name
> would take little work (basically removing the AI_NUMERICHOST flag
> passed to getaddrinfo in hba.c).  There was once a good reason not
> to allow it: slow DNS lookups would lock up the postmaster.  But
> now that we do this work in an already-forked backend, with an overall
> timeout that would catch any indefinite blockage, I don't see a good
> reason why we shouldn't let people use DNS names.
> Thoughts?
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

In response to


pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2006-01-02 04:38:09
Subject: Re: psql & readline & win32
Previous:From: Tom LaneDate: 2006-01-02 03:35:18
Subject: Re: SIGALRM in autovacuum.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group