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@xxxxxxxxxxxxxxx> wrote:
pg_settings show localhost.
Jason L. Amerson
-----Original Message-----
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson <drjason@xxxxxxxxxxxxxxx>
Cc: 'Steve Crawford' <scrawford@xxxxxxxxxxxxxxxxxxxx>; 'Adrian Klaver'
<adrian.klaver@xxxxxxxxxxx>; 'PostgreSQL'
<pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Remote Connection Help
"Jason L. Amerson" <drjason@xxxxxxxxxxxxxxx> 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.'
'If at first you dont succeed, dont take up skydiving.'
