would that result in the "unknown host" message i'm getting with the OSX
psql or would that result in the "no user myName is listed in the
pg_hba.conf file for IP address xxxx" that i'm getting with the cygwin
version of psql?
rjsjr
> -----Original Message-----
> From: PG Explorer [mailto:pgmail@pgexplorer.com]
> Sent: Wednesday, April 24, 2002 4:53 PM
> To: Robert J. Sanford, Jr.; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 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@postgresql.org
>
>