Come disattivare log metriche per PostgreSQL Flexible server

Question

Nel mio account di storage continua a crearsi una cartella chiamata insights-metrics-pt1m

dove all'interno c'è una sottocartella con il nome del servizio postgresql flexible server.

Ho verificato che su quest'ultimo non ci siano log di diagnostica attivi collegati all'account di storage, ma dopo aver cancellato il file dopo qualche minuto lo ritrovo ricreato.

All'interno ci sono tutte le metriche del server postgresql flexible.

Come posso disabilitare il log di queste metriche nel mio account di storage?

Answer 1

Hello @Anthony,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others", I'll repost your solution in case you'd like to accept the answer.

Solution:

First of all, a big thank you to everyone for their support and patience — I really appreciate it! We love working with Azure and collaborating with this community.

The issue was related to the diagnostic settings in PostgreSQL Flexible Server.

Even after Anthony removed the All Metrics diagnostic setting, the logs continued to be written to my Storage Account for several days before they stopped.

After a deeper investigation, Anthony followed these steps to fix the problem:

Steps Taken:

Check the diagnostic settings:

• Sign in to the Azure portal → PostgreSQL Flexible Server.
• Go to Monitoring → Diagnostic Settings.
• Make sure that there are no active diagnostic settings that forward logs to your Storage Account.

Note:

When saw that the log files were still generating even when there were no active diagnostic settings, Anthony added a new diagnostic for All Metrics, and then Anthony deleted it. Anthony thought that the first delete was not received from Azure, so Anthony tried to recreate the diagnostic and re-delete it in order to force the deleting of the metric.

Manually delete existing logs:

• Sign in to your Storage Account.
• Locate and delete the folder: .insights-metrics-pt1m

Check Azure Monitor or Insights:

• Ensure Azure Monitor, Log Analytics, or any third-party tools aren't collecting PostgreSQL logs.
• Even after disabling logging, logs might continue to be generated for a few hours or days due to internal Azure processes.

Check Storage Account Activity:

• If the logs keep reappearing, check if other Azure services are writing data to your Storage Account.

After following these steps, Anthony noticed that the folder .insights-metrics-pt1m was no longer being recreated, confirming that the issue was resolved.

If the answer is helpful, please click Accept Answer and kindly upvote it by click yes so that other people who face similar issues may benefit from it.