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

i don't know if i have said this before but i can use dbvisualizer with the
postgres jdbc library to connect to either of the machines successfully both
internally and externally.

i was talking to both my boss and my network admin and they were wondering
if there is something to do with configuring access to non-routable IP's
under OSX...

what do i need to do with netinfo manager, just try and add in a machine?

rjsjr

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Robert J.
> Sanford, Jr.
> Sent: Thursday, April 25, 2002 3:21 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] odd psql behaviour on OSX
>
>
> okay, i'm doing a little more testing and i have some oddities. i'm hoping
> to get some additional help with the additional info i'm providing here.
>
> i'm testing in two different networks - at home and at work. each of the
> networks has postgres server on it. both of the servers have a public and
> private ip address for each of the networks. the private ip
> address for both
> is a 192.168.69.xxx and the public ip address is, well, a public
> ip address.
>
> the network at home is a cable modem network with a linksys
> router/firewall
> that is assigning dynamic ip addresses. the router passes requests coming
> from outside through the port that i have selected to the machine running
> postgres. when i attempt to use psql to access the private ip
> address i get
> the unknown host error listed below. when i attempt to use psql to access
> the public ip address it responds and lets me in!
>
> the network at work is running a bunch of cisco routers and
> switches and all
> that good sort of stuff that i have no control over. when i attempt to
> access the private ip address from my osx machine it fails to connect with
> the unknown host error. when i try to connect to the public ip address it
> also fails with the same error. when i try to connect to either the public
> or private ip addresses from a windows machine running cygwin (i've tried
> from both at work and at home) it works just fine.
>
> i have loaded up the netinfo manager application listed below but
> i have no
> idea as to what to do with it. i'm not a unix guy by any stretch of the
> imagination. not afraid of it, just don't any experience with it
> but willing
> to learn.
>
> from my network at work i have explicitly set the DNS servers but still no
> joy.
>
> i can still ping the server and get a response but psql is not seeing it.
>
> aaaaaauuuuuuugggggghhhhhhhh!
>
> so why can i see the one public ip address but not the other or the two
> private ip addresses?
>
> many thanks!
>
> rjsjr
>
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Gregory Seidman
> > Sent: Wednesday, April 24, 2002 10:48 PM
> > To: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] odd psql behaviour on OSX
> >
> >
> > Robert J. Sanford, Jr. sez:
> > } 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.
> >
> > Incidentally, MacOS X normally ignores the /etc/hosts file. If
> you want to
> > set up that sort of thing, you need to do it in NetInfo Manager.app (or
> > with niutil) to add an entry to /machines.
> >
> > } 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?
> >
> > I am using the same package and version without any such difficulties. I
> > suspect that it is a DNS issue. See if it has the same problem if
> > you add a
> > period to the end of the host. This will make the DNS lookup
> behave a bit
> > differently (I forget exactly what it shortcuts... maybe just expanding
> > with search domains, maybe all lookups altogether on a numeric address).
> > Thus:
> >
> > psql -h 192.168.1.128. -U myName myDBName
> >
> > } rjsjr
> > --Greg
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>