On 11/21/19 12:07 PM, Jason L. Amerson wrote:
pg_settings show localhost.
Lets back up a bit and:
1) Show output of ps ax | grep post on Ubuntu machine.
2) Explain how you installed Postgres, source, package and if
package from what repo?
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx