Question
Configure OpenVPN to connect to PostgreSQL on Ubuntu 14.04?
I recently installed the one-click app for Django and then installed OpenVPN with the follow script, https://github.com/Nyr/openvpn-install. I am able to VPN to the server and see my traffic gets routed to it. However I can not see port 5432. Is there a tutorial or previous post someone can refer me to on configuring PostgreSQL 9.3 over OpenVPN?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
By default on the Django One-Click, postgres is bound to localhost and not accessible remotely. Have you already edited your postgres config to allow external access? What’s the output of
netstat -plunt
This should show you what services are listening and which ports they are listening on.I do not want to open DB access up to the world. I thought If I set up a VPN I would be able to access the server, transfer files between it, and access the different services running on it, which I am having an issue accessing postgres. Are you saying in order to access postgres, even tho I am connected via VPN, I would need to append the config file with some other IP? Any way to do that so that anyone connected via VPN can have access to the DB?
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.