I usually work in QGIS with many layers, connecting to various PostgreSQL databases.
Recently I often find myself in a situation where I need to work simultaneously with databases from different sources and often I’m stuck in a limbo where I can connect correctly via VPN to a remote server (Ubuntu), but I’m not able to connect to a server from a computer in my local network (Windows) and viceversa.
Any idea to how set properly the environment to access both sources at the same time?
Both machine run PostgreSQL v12. Thanks for any help!

I set up correctly the way I see folders and files on the remote server, so I can access both computers at the same time in Windows Explorer, but in PostgreSQL I cannot see the local server when open VPN via OpenConnect