Re: Remote Connection Help

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(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>
> Cc: '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
>
> "Jason L. Amerson" <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
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com