Hi Patrick RANDRIANJATOVO •,
Welcome to Microsoft Q&A forum.
As I understand, you are unable to connect to Azure PostgreSQL and getting "could not translate host name "xxxxx.postgres.database.azure.com" to address: Temporary failure in name resolution"
This error might be temporary due to some maintenance operation.
In the meantime, could you please try to connect using Azure CLI to check if server exists https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/quickstart-create-server-cli?
Also, is your server under virtual network?
Thanks