Re: Remote Connection Help

On 11/21/19 7:15 AM, Jason L. Amerson wrote:
> Steve,
>
> I cannot connect to the server by “psql -h xx.xx.xx.xx.” I can connect
> to my Ubuntu machine from other computers using SSH and I can connect to
> PostgreSQL if I SSH first. But I cannot connect directly to PostgreSQL
> either through a client machine or if I run “psql -h xx.xx.xx.xx” while
> using my Ubuntu machine.

1) Is the Postgres server listening on port 5432?

2) What is the full remote connection string you are using?

3) What is the remote machine, a hosted virtual machine, your own
physical machine, etc?

>
> Jason L. Amerson
>
> *From:*Jason L. Amerson <drjason(at)alphagenius(dot)org>
> *Sent:* Thursday, November 21, 2019 09:22 AM
> *To:* PostgreSQL <pgsql-general(at)lists(dot)postgresql(dot)org>
> *Subject:* Remote Connection Help
>
> I am at a loss for what to do. I have read article after article about
> how to allow remote connections on my PostgreSQL server and none of what
> the articles say do, worked for me. I have edited the “postgresql.conf”
> file and changed “listen_address = ‘localhost’ to listen_address = ‘*’.
> I have even tried it commented out and uncommented and I get the same
> results. I also edited the “pg_hba.conf” file and added the following at
> the end of the file:
>
> host all all 0.0.0.0/0 md5
>
> host all all ::/0 md5
>
> After that I restart the server, try to connect remotely, and I get
> nowhere. I have even added the following rules to my iptables:
>
> iptables -A INPUT -p tcp -s 0/0 --sport 1024:65535 -d xx.xx.xx.xx
> --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT
>
> iptables -A OUTPUT -p tcp -s xx.xx.xx.xx --sport 5432 -d 0/0 --dport
> 1024:65535 -m state --state ESTABLISHED -j ACCEPT
>
> My computer that is running the server is Ubuntu and it has a static IP.
> I am trying to connect remotely with computers running Windows 10 using
> the static IP. When I run pgAdmin from my Windows 10 machine, or use the
> command line to connect, I get the following error:
>
> unable to connect to server:
>
> could not connect to server: Connection refused (Ox0000274D/10061) Is
> the server running on host " xx.xx.xx.xx" and accepting
>
> TCP/IP connections on port 5432'
>
> I would like to be able to connect to my Ubuntu PostgreSQL server from
> all Windows 10 machines as well as from a client on my Android phone
> while away from home. That is my goal now. I am hoping that someone can
> help me to get this working. This is been very frustrating.
>

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