Remote access postgresql tables

Question

Hi,
I want to use pgAdmin on my local computer to browse in the tables.
The postgresql Port is listening (checked with netstat), but I can't connect.
I'll get a timeout.
Is there anything else I have to configure?

Best regards
Stephan

This thread was automatically locked due to age.

bennyv · Answer

Hey Mate,  Sorry for the stupid late reply. I forgot to check back. Hopefully this article helps. Linux: Iptables Allow PostgreSQL server incoming request   I'm not sure of your setup, but if you've got a production system at the moment. I recommend installing the trial and testing everything on the trial before you touch production.

packetdog · Answer

Hi All, 
 
 I wanted to add that I was finally able to get this working, so I thought I would share. Clearly the UTM is locked down and doesn't allow access to the database from external sources. Instead of playing with IP Tables and possibly making the firewall weaker, I did the following: 
 
 -Logged into Webadmin, Enabled SSH, set password for LoginUser account 
 -Created a PuTTY session to UTM internal address from internal network, setting up a port forward tunnel. I mapped local port 5432 to 127.0.0.1:5432 (in this case, 127.0.0.1 refers to the UTM, i.e. the other end of the tunnel) 
 -Installed pgAdmin 4.1 and entered 127.0.0.2 (backup localhost address for Windows PCs.. may work with .1, but I've had issues using .1 w/RDP port tunneling in the past, so it's habit) as the IP to use, and boom went right in. 
 
 Hope this helps someone else. Now I just need to figure out where to change the setting for SMTP Logging. I can't deal with 30 days.. I run a small mail server with not a lot of traffic. I'll start with 90, but may go as high as 180. 
 
 This was done on a Windows 7 x64 PC from the local network to the UTM.