How to configure a remote connection with PostgreSQL

How to configure a remote connection with PostgreSQL



How to connect to a remote database PostgreSQL Server.
Features:
Virtualitzation with Virtual Box

Server:
Operating system: Linux Debian ver. 8
Memory: 512 MB
PostgreSQL server version 9.4

Client:
Operating system: Linux Debian ver. 8
Memory: 512 MB
PostgreSQL client version 9.4

5 thoughts on “How to configure a remote connection with PostgreSQL

  1. I have changed the config listen adresses to '*' and in the hba added 0.0.0.0/0 and it still don't work. I can perfectly telnet port 5432 from the server and server ip adres. I've tried many different things, searched for many hours but I can't fix this damn shit. I can connect to it from my school netwerk where server also stored but that's it. The server keepers also can't help for shit.

  2. Check if your Fedora install included firewalld (The new replacement for iptables).

    ps -aux | grep firewalld

    If it exists you need to open the Postgresql remote access port, 5432. By default this port is closed.

    #firewall-cmd –permanent –add-port=5432/tcp

    You should now be able to access from a remote system i.e PGadmin installed on Windows.

Leave a Reply

Your email address will not be published. Required fields are marked *