Re: DNS vs /etc/hosts

Both dig and nslookup are fast on all machines. 'psql' is fast on all
machines, as long as I am using the version compiled with version 7.2. It
is only 'psql' compiled with version 8.0 that is slow. I don't think DNS
is the problem, but rather the way psql in version 8.0 attempts to get the
DNS info. My Linux kernal version is 2.4.18.

"WELTY, RICHARD" <richard(dot)welty(at)bankofamerica(dot)com>
Sent by: pgsql-general-owner(at)postgresql(dot)org
08/04/2005 03:46 PM

To
Richard_D_Levine(at)raytheon(dot)com, pgsql-general(at)postgresql(dot)org
cc

Subject
Re: [GENERAL] DNS vs /etc/hosts

nslookup isn't the easiest tool for use in diagnosing dns problems
as it goes through the whole messy nsswitch process, and doesn't
readily isolate much of anything.

the dig command focuses on dns only, skips nsswitch altogether,
and lets you rule dns problems in or out in one swell foop. if
dig is fast and nslookup is slow, then you need to examine
/etc/nsswitch for foulups.

richard

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of
Richard_D_Levine(at)raytheon(dot)com
Sent: Thursday, August 04, 2005 4:29 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] DNS vs /etc/hosts

Sorry to re-reply, but I had a much simpler idea. From the client machine
that is slow to connect, type the command "nslookup hostname1". If it
takes 15 seconds. If it does, DNS is the problem.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster