Re: odd psql behaviour on OSX

"Robert J. Sanford, Jr." <rsanford(at)nolimitsystems(dot)com> writes:
> i am running postgresql 7.2 for OSX (10.1.4?) that was pre-built by marc
> liyange (thank you very much mr. liyange!). whenever i'm working on my local
> machine everything works gloriously. but when i attempt to use psql to
> attach to a remote host i always receive the error message of "unknown
> host".

> i will type in a command line of
> $psql -h 192.168.1.128 -U myName myDBName

> and get back
> psql: unknown host:192.168.1.128

Odd. It works fine for me with either host names or host numbers
(I'm using OS X 10.1 on a G3 laptop). Normally I'd be inclined to blame
misconfiguration of your DNS setup, but if you can contact the remote
host with other programs then that answer may not hold water.

Is the message spelled exactly that way? The closest thing I can find
in the source code is "unknown host name: %s", which is reported after
a gethostbyname() failure. If you've transcribed the message accurately
then it must be coming from some OSX-specific subroutine. But if it is
reporting gethostbyname() failure then I'd bet something is wrong with
your lookupd configuration (see "man lookupd").

regards, tom lane