Server logs option in Azure PostgreSQL Flexible Server

Question

I am currently using Azure PostgreSQL single server and planning to upgrade to Azure PostgreSQL Flexible Server.
One of the drawback I came across was "Server Logs" option is not available under Monitoring pane in Azure PostgreSQL Flexible Server.
This is easily available in Azure PostgreSQL Single Server which generates nice logs output on hourly basis.
Can anyone help me with where to find such Server Logs option in Azure PostgreSQL Flexible Server or any alternate option where logs will be generated on hourly basis ??

Answer 1

Hi @sappu solanki , welcome to Microsoft Q&A forum.

As I understand, you would like to access the server logs in Azure PostgreSQL - Flexible Server similar to Single Server.

To achieve this, we need to configure Monitoring -> Diagnostic Settings as mentioned in the below screenshot. Then we need to choose one of destination details (like Log Analytics Store) that will store our logs:

Once this is configured, the logs will flow to Azure Log Analytics workspace and we can run below query to get them.

AzureDiagnostics   
| where Category == "PostgreSQLLogs"  

Referenced Article: Configure and Access Logs in Azure Database for PostgreSQL - Flexible Server

Please let us know if this helps or else we can discuss further on the same.

----------

If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!