On Thu, Aug 04, 2005 at 10:13:43AM -0500, Lowell.Hought@xxxxxxx wrote: > 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? Have you determined whether the difference is in the client (psql), in the server, or in both? What happens if you use a 7.2 client to connect to an 8.0 server, and if you use an 8.0 client to connect to a 7.2 server? Have you run a process trace or network sniffer to test your hypothesis? Let's find out exactly what and where the problem is before looking for a solution. But if DNS is the problem, why not fix it instead of working around it? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
