Remote Connection Help

"Jason L. Amerson" <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <!&!AAAAAAAAAAAuAAAAAAAAAGmIF169jV1Ig2e+e0GOo/YBAMO2jhD3dRHOtM0AqgC7tuYAAAAAAA4AABAAAAAse4DPB0qGQZhIy/[email protected]>

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.
image001.gif (image/gif, 1.1 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.