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.welty@xxxxxxxxxxxxxxxxx>
Sent by: pgsql-general-owner@xxxxxxxxxxxxxx 08/04/2005 03:46 PM |
|
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@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of
Richard_D_Levine@xxxxxxxxxxxx
Sent: Thursday, August 04, 2005 4:29 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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
