Can server logs be enabled for Postgres Flexible server using BICEP code?

Question

Hello,

Is it possible to enable server logs for Postgres Flexible server via BICEP code or does it have to be done through the GUI? For example, we can turn on diagnostics using "Microsoft.Insights/diagnosticSettings@2021-05-01-preview".

Answer 1

@Sai Praneeth Eranti Thank you for reaching out.

You can achieve the above using GUI or CLI or Bicep

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-server-logs-cli

there are two parts here

1. Configuring the logs for Log Analytics (LA)
   • One time setup
     • Can be done via Portal, CLI, Bicep
2. Query the logs via KQL
   • Querying has to be done via any Kusto client (Azure portal, Kusto explorer, PowerShell etc.)

Regards,

Oury

Answer 2

As per MS , There is no API code for BICEPS to enable server logs for an Azure PostgreSQL Flexible server. You can only achieve this using CLI or the portal functionality.