Can Azure devops resolve hostnames of postgresql flexible servers in private DNS zone with private access enabled>
I am using a combination of Azure devops and terraform to provision our environments on the fly and configure them.
During the various stages of our pipeline we are creating a postgreSQL DB felxible server and subsequently creating a user on it in the next stage/job.
The problem is if the flexible server has public access, Azure pipelines is able re resolve hostname and create user. But when we launch the Db with private access and a private DNS zone, the pipeline is unable to resolve the hostname and thus failing to create a user.
Is it possible for Azure devops (azure hosted agents) to resolve hostnames for the flexible server in this case?
PS : I looked into private endpoint but it is probably not available for flexible servers as of now.