Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity

Question

Hi,

I need to deploy a webApp running .NET Code and Azure Database for PostgreSQL flexible server.

Our policy is to grant webApps/functionApps access to SQL Server/MySql Server/PostgreSQL Server via Managed Identity.

While, I can see connection strings in Azure Portal for sql Server that I have used to grant connect web App and SQL Server via Managed Identity but there is no connection string for Azure Database for PostgreSQL flexible server in this regard.

Connection String - PostgreSQL flexible server.jpg

We cannot hardcode login credentials in connection String mentioned on Azure Portal as shown below: Server=postgreserverweu-prod.postgres.database.azure.com;Database=postgres;Port=5432;User Id=maiaAdmin;Password={your_password};Ssl Mode=Require;

I cannot find any documentation on Microsoft Learn in this regard except this where a VM is being granted access to PostgreSQL server via Managed Identity:

https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-connect-with-managed-identity

Kindly confirm whether Azure supports Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity. If yes, kindly share connection String ASAP.

Answer 1

@84017655 Thanks for the update, on your additional question.

Yes, you can create your databases as a nested resource when you're creating your server, or as an external

resource myserver 'Microsoft.DBforPostgreSQL/flexibleServers@2023-06-01-preview' = {

 location: 'mylocation'

  name: servername

  resource database 'databases' = {

    name: 'mydb'

  }

}

 or as an external resource with parent == your server, as documented here:

 Microsoft.DBforPostgreSQL/flexibleServers/databases - Bicep, ARM template & Terraform AzAPI reference | Microsoft Learn

Please let me know if you need any additional information.

Regrads

Geetha