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.