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
what is exemple?
I am looking for the same command from 0:14 but working on Windows 10
Didn’t really explain anything. How do I open the config files?
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.
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.