Remote Connection Help

From: "Jason L(dot) Amerson" <drjason(at)alphagenius(dot)org>
To: "PostgreSQL" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Remote Connection Help
Date: 2019-11-21 14:21:59
Message-ID: !&!AAAAAAAAAAAuAAAAAAAAAGmIF169jV1Ig2e+e0GOo/YBAMO2jhD3dRHOtM0AqgC7tuYAAAAAAA4AABAAAAAse4DPB0qGQZhIy/hSwvrXAQAAAAA=@alphagenius.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Loftis 2019-11-21 14:23:50 Re: Extract transaction from WAL
Previous Message Ron 2019-11-21 14:18:21 Re: Isolation of multiple databse instances provided by a single postgres server