Configure OpenVPN to connect to PostgreSQL on Ubuntu 14.04?

This question was answered by @speelman90:

I was able to figure it out. Not positive if openvpn will always bind my connection to the same ipaddress tho…

This is what I did.

1. Connect to openvpn server
2. Run ifconfig and ipconfig to get the ipaddress for the server and local machine over vpn
3. Edit /etc/postgresql/9.3.main/postgresql.conf. Uncommented and edited line: listen_addrress = ‘[ip address from for the local machine over the vpn], localhost’.
4. Edit /etc/postgresql/9.3.main/pg_hba.conf. Added ipv4 record: host all all [ip address of local machine over vpn]/24 md5
5. Installed iptables-persistant and ufw. Enabled ufw.
6. Added to entries to iptables and saved: iptables -A INPUT -p tcp -s 0/0 --sport 1024:65535 -d [local machine ip over vpn] --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A OUTPUT -p tcp -s [local machine ip over vpn] --sport 5432 -d 0/0 --dport 1024:65535 -m state --state ESTABLISHED -j ACCEPT
7. Rebooted the server.

View the original comment