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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Why don't we allow DNS names in pg_hba.conf?
Дата
Msg-id 26901.1136140246@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Why don't we allow DNS names in pg_hba.conf?  ("Marc G. Fournier" <scrappy@postgresql.org>)
Re: Why don't we allow DNS names in pg_hba.conf?  (Peter Eisentraut <peter_e@gmx.net>)
Re: Why don't we allow DNS names in pg_hba.conf?  (Andrew Dunstan <andrew@dunslane.net>)
Re: Why don't we allow DNS names in pg_hba.conf?  (elein <elein@varlena.com>)
Список pgsql-hackers
I was reminded of $subject by
http://archives.postgresql.org/pgsql-admin/2006-01/msg00002.php

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Removing SORTFUNC_LT/REVLT
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Why don't we allow DNS names in pg_hba.conf?