Re: odd psql behaviour on OSX

You have you add your client's ip in the $PGDATA/pg_hba.conf

That should do it.

http://www.pgexplorer.com

> 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
>
> that server responds when i ping it. i have tried adding entries into my
> hosts file and restarting the system but that didn't help either. i have
> tried the -p 4532 option to specify the port but that doesn't work either.
>
> when i use dbvisualizer with the postgresql jdbc driver i can connect with
> no problems. when i try psql on a win2k machine using cygin i can connect
> with no problems. this leads me to believe that there is an issue with
psql
> accessing the network on osx.
>
> any ideas and/or suggestions?
>
> rjsjr
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org