Postgres Pro
Downloads
Home   >   mailing lists

Re: Remote Connection Help - Mailing list pgsql-general

From Andrew Kerber
Subject Re: Remote Connection Help
Date
Msg-id CAJvnOJamB7vnfYkFc7A9nk5upvDFk89wOU2nf3jn69AQf3-U4A@mail.gmail.com
Whole thread Raw
In response to RE: Remote Connection Help  ("Jason L. Amerson" <drjason@alphagenius.org>)
Responses RE: Remote Connection Help
List pgsql-general
Tree view
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@alphagenius.org> wrote:
pg_settings show localhost.

Jason L. Amerson


-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson <drjason@alphagenius.org>
Cc: 'Steve Crawford' <scrawford@pinpointresearch.com>; 'Adrian Klaver'
<adrian.klaver@aklaver.com>; 'PostgreSQL'
<pgsql-general@lists.postgresql.org>
Subject: Re: Remote Connection Help

"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.'

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Remote Connection Help
Next
From: Tom Lane
Date:
Subject: Re: Remote Connection Help