Re: Remote Connection Help

From: Andrew Kerber <andrew(dot)kerber(at)gmail(dot)com>
To: "Jason L(dot) Amerson" <drjason(at)alphagenius(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PostgreSQL <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Remote Connection Help
Date: 2019-11-21 20:16:55
Message-ID: CAJvnOJamB7vnfYkFc7A9nk5upvDFk89wOU2nf3jn69AQf3-U4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is your hosts file configured correctly? Is there an entry for the IP
address you are using in your hosts file? And does it point to the correct
hostname and ip address?

On Thu, Nov 21, 2019 at 2:07 PM Jason L. Amerson <drjason(at)alphagenius(dot)org>
wrote:

> pg_settings show localhost.
>
> Jason L. Amerson
>
>
> -----Original Message-----
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Sent: Thursday, November 21, 2019 02:42 PM
> To: Jason L. Amerson <drjason(at)alphagenius(dot)org>
> Cc: 'Steve Crawford' <scrawford(at)pinpointresearch(dot)com>; 'Adrian Klaver'
> <adrian(dot)klaver(at)aklaver(dot)com>; 'PostgreSQL'
> <pgsql-general(at)lists(dot)postgresql(dot)org>
> Subject: Re: Remote Connection Help
>
> "Jason L. Amerson" <drjason(at)alphagenius(dot)org> writes:
> > Yes "listen_addresses" is not commented. I did notice when I did the
> netstat, for tcp, it was all "127.0.0.1" on various ports including 5432
> but
> I have a listing for tcp6 that has my static IP using port 32305. Would
> that
> make a difference?
>
> Hm, well, *something* is overriding the setting. What did you find in
> pg_settings?
>
> regards, tom lane
>
>
>
>
>
>

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-11-21 20:31:51 Re: Remote Connection Help
Previous Message Adrian Klaver 2019-11-21 20:16:50 Re: Remote Connection Help