I have one web application, that is deployed on cloud. Now, this web application needs to access 3 Postgres databases, located in 3 different location(Lets call them, client systems).
So one day, I met with this guy, who is very experienced and senior to me. He gave me following solution.
- Install OpenVPN on Raspberry Pi
- Put this Raspberry Pi in the network (behind the firewall, he said) where Postgres database server is installed.
- Access Postgres databases via VPN from cloud.
Now I am wondering why I need to do this when I can access all 3 databases by just doing port forwarding from client systems.
Am I missing something ?