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@xxxxxxxxxxxxxxx>
*Sent:* Thursday, November 21, 2019 09:22 AM
*To:* PostgreSQL <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
*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.klaver@xxxxxxxxxxx
