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.
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@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Richard_D_Levine@raytheon.com Sent: Thursday, August 04, 2005 4:29 PM To: pgsql-general@postgresql.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