I have a dockerized PG Manager (PGM) on a VPS machine. On the same machine, I also have a database with several tables. On PGM, I setup the database access with (host, port, database, username, password). Sofar so good. However, I set host as the VPS IP, which takes more time to data access because of latency. I tried using localhost, but it cannot resolve to the local database. I have a vague idea of working with docker network, but making it access an immediate network on the same machine is a nwe challenge for me.

I have web application which has pre prod and prod environments.

I have web application which has pre prod and prod environments.