The following bug has been logged online:
Bug reference: 1078
Logged by: Josh Rovero
Email address: rovero@sonalysts.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