title: Why can't I connect to Azure Postgresql flexible using Hostname
body: <p>The Hostnameof the Postgresql flexible is name.postgres.database.azure.com, it's inside a private network.
  Connecting with the private IP address using VPN (IKEv2)  works for me.
  If I try to connect or ping  to the hostname then it gives this error:
  [could not translate host name &quot;name.postgres.database.azure.com.&quot; to address: Unknown host]
  The Azure Private DNS is also linked with the VNet.
  Any suggestion how it could be solved?</p>