How can we help you today? How can we help you today?

No data for Azure Postgres - logging_collector param can't be enabled?

Hey there. I've updated Redgate Monitor to the recent version so that I can connect it to Azure Postgres Flexible Server.

I've done almost* everything listed in https://documentation.red-gate.com/monitor14/preparing-postgresql-for-monitoring-239667737.html and managed to connect to the Postgres in Redgate, however the data for it is empty:



* I said "almost", because there was one parameter I couldn't set: logging_collector . It's disabled by default in Azure and can't be changed.



Perhaps that's the cause. What should I do about it, for the postgres queries to appear in Redgate?
Jacek
0

Comments

2 comments

Sort by
  • Sujay
    Hi,

    For Azure Flexible server, could you check if the steps suggested at https://documentation.red-gate.com/monitor14/enabling-advanced-monitoring-for-azure-flexible-server-266141724.html help to get this working?

    Sujay
    0
  • jtom
    No we didn't, but it's written there that those steps are only for

    > Advanced monitoring for Azure Flexible instances covers host metrics related to disk capacity & usage, memory usage, and operating system process information. 

    We don't miss just disk/memory usage metrics. Everything's missing - not a single query is logged nor any information about any of the databases.
    jtom
    0

Add comment

Please sign in to leave a comment.