RE: Remote Connection Help

I have attached a screenshot of my hosts file. My static IP is not listed in the file. The second line where it has “thuban”, Thuban is my machine’s name.

Jason L. Amerson

From: Andrew Kerber <andrew(dot)kerber(at)gmail(dot)com>
Sent: Thursday, November 21, 2019 03:17 PM
To: Jason L. 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

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 <mailto: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 <mailto: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 <mailto:drjason(at)alphagenius(dot)org> >
Cc: 'Steve Crawford' <scrawford(at)pinpointresearch(dot)com <mailto:scrawford(at)pinpointresearch(dot)com> >; 'Adrian Klaver'
<adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com> >; 'PostgreSQL'
<pgsql-general(at)lists(dot)postgresql(dot)org <mailto:pgsql-general(at)lists(dot)postgresql(dot)org> >
Subject: Re: Remote Connection Help

"Jason L. Amerson" <drjason(at)alphagenius(dot)org <mailto: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.'