Re: Remote Connection Help

On Thu, Nov 21, 2019 at 8:48 AM Jason L. Amerson <drjason(at)alphagenius(dot)org>
wrote:

> 1) I am not sure if Postgres server is listening on port 5432. How do I
> check?
>
> 2) I have tried "psql -h xx.xx.xx.xx" and "psql -h xx.xx.xx.xx -U
> postgres."
> I even tried to telnet to it using the static IP and port 5432 but it would
> not connect. I can connect to it remotely using the static IP with SSH.
>
> 3) It is my own physical machine. It is running Ubuntu and has a static IP.
>
> Jason L. Amerson
>
> ....

Can you connect locally? I.e. on the machine running PostgreSQL? If so, you
can run:

show listen_addresses;

and

show port;

to verify the settings. On some distros (including Ubuntu) you can have
PostgreSQL running on a non-standard port due to an upgrade or installation
of multiple versions.

Other thoughts. Did you restart PostgreSQL after changing settings? Are you
sure that you are editing the postgresql.conf file associated with your
running instance? Is there anything on the *client* machine or between the
client machine and your PostgreSQL server that could be blocking ports?
Have you used netstat or lsof to verify that PostgreSQL is listening on
5432?

Cheers,
Steve