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.kerber@gmail.com> Sent: Thursday, November 21, 2019 03:17 PM To: Jason L. Amerson <drjason@alphagenius.org> Cc: Tom Lane <tgl@sss.pgh.pa.us>; Steve Crawford <scrawford@pinpointresearch.com>; Adrian Klaver <adrian.klaver@aklaver.com>; PostgreSQL <pgsql-general@lists.postgresql.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?
"Jason L. Amerson" <drjason@alphagenius.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.'
