Skip site navigation (1) Skip section navigation (2)

Re: BUG #1045: hostname lookup in psql or libpg.sl does work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: keith_halewood(at)systems-intelligence(dot)com
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1045: hostname lookup in psql or libpg.sl does work
Date: 2004-01-09 02:22:33
Message-ID: 19589.1073614953@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> psql (and libpg.sl via the DBI and DBD::Pg interface) report:
> psql: could not translate host name "ysolde" to address: host nor service 
> provided, or not known 

Couldn't duplicate this using HP's testdrive systems (HP 11.11).

I do get a message of exactly that spelling when providing a
deliberately incorrect hostname, though.  I suspect pilot error on
your part, or misconfiguration of your DNS setup.

$ uname -a
HP-UX spe191 B.11.11 U 9000/800 1865940626 unlimited-user license

-- spe176 is a nearby machine that's not in /etc/hosts:

$ nslookup spe176
Using /etc/hosts on:  spe191

looking up FILES
Trying DNS
Name:    spe176.testdrive.hp.com
Address:  192.233.54.176

$ psql -l -p 5440 -h spe176
psql: could not connect to server: Connection refused
        Is the server running on host "spe176" and accepting
        TCP/IP connections on port 5440?
$ psql -l -p 5440 -h spe176.testdrive.hp.com
psql: could not connect to server: Connection refused
        Is the server running on host "spe176.testdrive.hp.com" and accepting
        TCP/IP connections on port 5440?
$ psql -l -p 5440 -h spe17dddfqz
psql: could not translate host name "spe17dddfqz" to address: host nor service provided, or not known
$

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Jonathan PurvisDate: 2004-01-09 03:01:34
Subject: JDBC driver doesn't handle NaN values
Previous:From: Tom LaneDate: 2004-01-09 00:16:06
Subject: Re: Fwd: Bug#224716: postgresql-client: createuser fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group