Re: DNS vs /etc/hosts

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Lowell(dot)Hought(at)faa(dot)gov
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: DNS vs /etc/hosts
Date: 2005-08-04 15:56:22
Message-ID: 1123170982.15416.75.camel@sabrina.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
Lowell(dot)Hought(at)faa(dot)gov:
>
> I am changing from 7.2 to 8.0 and have both installed now on various
> Linux machines. When I use the psql command line interface with a -h
> hostname, the connection time from 7.2 is instant while the connection
> time from 8.0 is 15 seconds. My assumption is that 7.2 checks
> the /etc/hosts file first and if unable to find the specified host it
> reverts to a DNS lookup, and the 8.0 is just the opposite. Is this a
> correct assumption, and if so, can I modify 8.0 to behave as 7.2 does?

No, applications dont do lookups theirself.
The os (or rather the resolver lib) decides
how it works and therefore both 7.2 and 8.0
will behave the same.

I think you have different user policies in their
pg_hba.conf and 8.0 might (per default) want to
check ident. And if you firewall it or so it might
take a while to timeout.

--
Tino Wildenhain <tino(at)wildenhain(dot)de>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Scherrey 2005-08-04 15:57:32 Default size limit for 'character varying' in Postgres 8?
Previous Message Lowell.Hought 2005-08-04 15:13:43 DNS vs /etc/hosts