Search Postgresql Archives

Re: DNS vs /etc/hosts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Machine 1 is running version 8.0
Machine 2 is running version 7.2
Machine 3 has version 7.2 and version 8.0 installed, so both versions of "psql" are available for testing.

From machine 3 to machine 2
Version 7.2 psql  -  /usr/bin/psql -d dbname -h machine2   ---- connection time instant
Version 8.0 psql  - /usr/local/pgsql/bin/psql -d dbname -h machine2 ---- conection time 15 seconds
Version 8.0 psql  - /usr/local/pgsql/bin/psql -d dbname -h ip.address ---- connection time instant

From machine 3 to machine 1
Version 7.2 psql   -  /usr/bin/psql -d dbname -h machine1   ---- connection time instant
Version 8.0 psql  - /usr/local/pgsql/bin/psql -d dbname -h machine1 ---- conection time 15 seconds
Version 8.0 psql  - /usr/local/pgsql/bin/psql -d dbname -h ip.address ---- connection time instant




Tino Wildenhain <tino@xxxxxxxxxxxxx>

Sent by: pgsql-general-owner@xxxxxxxxxxxxxx

08/04/2005 10:56 AM

To
Lowell Hought/AGL/FAA@FAA
cc
pgsql-general@xxxxxxxxxxxxxx
Subject
Re: DNS vs /etc/hosts





Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
Lowell.Hought@xxxxxxx:
>
> 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@xxxxxxxxxxxxx>


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux