From: | "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: odd psql behaviour on OSX |
Date: | 2002-04-24 22:34:59 |
Message-ID: | PHENKEEPJCPAMKFKNEOGAEMJDEAA.rsanford@nolimitsystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)pgexplorer(dot)com]
> Sent: Wednesday, April 24, 2002 4:53 PM
> To: Robert J. Sanford, Jr.; pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey Baker | 2002-04-24 22:35:44 | Re: No long-lived transaction, still can't delete tuples |
Previous Message | Tom Lane | 2002-04-24 22:21:31 | Re: No long-lived transaction, still can't delete tuples |