The following bug has been logged online:

Bug reference: 1078
Logged by: Josh Rovero

Email address: rovero (AT) sonalysts (DOT) com

PostgreSQL version: 7.4

Operating system: HP-UX 11.11

Description: Ref #1045 hostname lookup does not work

Details:

Box configured with /etc/hosts, NIS and DNS. Primary
source for IPs on local network is NIS, and works.
But psql (and connection attempts with libpq) fail.
Example:

uname -a
HP-UX levanto B.11.11 U 9000/800 554706577 unlimited-user license

nslookup jetstream
Using /etc/hosts on: levanto

looking up FILES
Trying NIS
Name: jetstream.sonalysts.com
Address: 198.6.213.78
Aliases: jetstream, jet

Other applications (telnet, ftp, ping) have
no problems resolving hostnames.

psql -h jetstream -U wxstat wxstation
psql: could not translate host name "jetstream" to address: host nor service
provided, or not known

psql -h 198.6.213.78 ... ... works.

Error does *not* occur on HP-UX B.11.00 box
with postgresql installed/built the same
way, and with identical pg_hba.conf and
postgresql.conf


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org