BUG #1088: Name resolution connecting to a database

The following bug has been logged online:

Bug reference: 1088
Logged by: Antonino Albanese

Email address: al(dot)an(at)sitvallee(dot)it

PostgreSQL version: 7.4

Operating system: Linux server.sitvallee.it 2.4.20-28.7smp #1 SMP Thu Dec
18 11:18:31 EST 2003 i686 unknown

Description: Name resolution connecting to a database

Details:

I'm using postgresql 7.4.1 exactly the rpm version:
nino(at)server:~$ rpm -qva|grep -i postgresql
postgresql-docs-7.4.1-1PGDG
postgresql-devel-7.4.1-1PGDG
postgresql-contrib-7.4.1-1PGDG
postgresql-server-7.4.1-1PGDG
postgresql-libs-7.4.1-1PGDG
postgresql-7.4.1-1PGDG
postgresql-pl-7.4.1-1PGDG

on a 7.3 RH Server:
Linux server.sitvallee.it 2.4.20-28.7smp #1 SMP Thu Dec 18 11:18:31 EST 2003
i686 unknown

all the tests where done directly on the database
server, but I've got the same behavior from different
clients, either using psql or the php interface

trying to connect to the server with domain name
takes long time, here an example:
nino(at)server:~$ time psql -h server -d newtestdb -U download -c '\q'

real 0m10.151s
user 0m0.010s
sys 0m0.000s

but every thing works fine if I use the IP address:
nino(at)server:~$ time psql -h 192.168.0.1 -d newtestdb -U download -c '\q'

real 0m0.023s
user 0m0.000s
sys 0m0.020s

here the content of my configuration files:
------------------------------------
/var/lib/pgsql/data/pg_hba.conf
------------------------------------
local all all ident sameuser
host sitvallee download 192.168.0.0 255.255.255.0 trust
host newtestdb download 192.168.0.0 255.255.255.0 trust
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.0 md5

------------------------------------
/var/lib/pgsql/data/postgresql.conf
------------------------------------
tcpip_socket = true
max_connections = 100
shared_buffers = 64000
sort_mem = 8192
effective_cache_size = 8000
datestyle = 'sql, european'
LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'

------------------------------------
/etc/host.conf
------------------------------------
order hosts,bind

------------------------------------
/etc/hosts
------------------------------------
127.0.0.1 localhost local # loopback
# Local Network.
192.168.0.13 capo.sitvallee.it capo
192.168.0.14 laptop.sitvallee.it laptop
192.168.0.10 devwin.sitvallee.it devwin
192.168.0.12 devgis.sitvallee.it devgis
192.168.0.11 devweb.sitvallee.it devweb
192.168.0.230 printer.sitvallee.it printer
192.168.0.1 server.sitvallee.it server
192.168.0.2 gateway.sitvallee.it gateway
192.168.0.5 switch.sitvallee.it switch

Hope I gave every needed information

Sincerely
Nino