Search Postgresql Archives

Re: Remote Connection Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux