Re: odd psql behaviour on OSX - Mailing list pgsql-general

From PG Explorer
Subject Re: odd psql behaviour on OSX
Date
Msg-id 000b01c1ebda$5642c9a0$c80ba8c0@sabex.com
Whole thread Raw
In response to odd psql behaviour on OSX  ("Robert J. Sanford, Jr." <rsanford@nolimitsystems.com>)
Responses Re: odd psql behaviour on OSX
List pgsql-general
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@postgresql.org


pgsql-general by date:

Previous
From: "Robert J. Sanford, Jr."
Date:
Subject: odd psql behaviour on OSX
Next
From: Stephan Szabo
Date:
Subject: Re: Why is outer Join way quicker?