I have set up a Postgresql database and am trying to connect with Python/psql through a VPN. I am using the connection string of the form "host=myhost.postgres.database.azure.com port=5432 dbname=postgres user=user password=mypw sslmode=require"
In networking, I whitelist the ip range corresponding to the private network, but cannot connect as I can with an MSSQL-server database using the same whitelist. I get the error:
psql: error: could not connect to server: Operation timed out
Is the server running on host "<hostname>" (<hostip>) and accepting
TCP/IP connections on port 5432?
When disconnecting from the VPN an allowing all ip's I can connect with psql.
I'm not able to follow the language in this post: https://stackoverflow.com/questions/56127851/connect-to-azure-database-for-postgresql-through-vpn but it sounds like there may be no resolution to this?