Re: odd psql behaviour on OSX

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
>
>

In response to

Browse pgsql-general by date

  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