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 <[email protected]> 
Sent: Thursday, November 21, 2019 03:17 PM
To: Jason L. Amerson <[email protected]>
Cc: Tom Lane <[email protected]>; Steve Crawford <[email protected]>; Adrian Klaver <[email protected]>; PostgreSQL <[email protected]>
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 <[email protected] <mailto:[email protected]> > wrote:

pg_settings show localhost.

Jason L. Amerson


-----Original Message-----
From: Tom Lane <[email protected] <mailto:[email protected]> > 
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson <[email protected] <mailto:[email protected]> >
Cc: 'Steve Crawford' <[email protected] <mailto:[email protected]> >; 'Adrian Klaver'
<[email protected] <mailto:[email protected]> >; 'PostgreSQL'
<[email protected] <mailto:[email protected]> >
Subject: Re: Remote Connection Help

"Jason L. Amerson" <[email protected] <mailto:[email protected]> > 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.'