Özkan Pakdil

10 February 2025

Redgate Monitor Support for Azure PostgreSQL Flexible Server

Azure Database for PostgreSQL on Azure Flexible server is now fully supported in Redgate Monitor (v14.0.43 and later). It provides:

• Advanced database monitoring – tracking long-term query performance trends, detecting slow-running queries, and surfacing execution plan inefficiencies.
• Azure infrastructure metrics – including CPU, memory, and storage usage, collected via the Azure Monitor API and displayed alongside database health.
• Error logging – PostgreSQL Error Logging (added in v14.0.39) integrates Flexible Server logs for easier issue diagnosis
• Secure authentication – Connect to the PostgreSQL instance securely using Managed Identity or Service Principal credentials (added in v14.0.40).

If you’ve added or are planning to add Flexible Server to your Redgate Monitor estate, we’d love to hear feedback on your experience and any suggestions for improvement (via the in-app feedback buttons or our ‘UserVoice‘ forum).

Adding PostgreSQL Flexible Server to Redgate Monitor

To add PostgreSQL on Azure Flexible Server, go to the Monitored Servers page, add a PostgreSQL instance, and select Azure Flexible Server as the environment. As with adding PostgreSQL on any other platform, some general configuration of the instance will be required and you can find stepwise instructions in the adding PostgreSQL documentation.

You’ll need to enable Advanced monitoring to capture machine metrics for your Azure Flexible PostgreSQL instance and provide an authentication method, with the option to choose an Entra Managed Identity or Service Principal if those are desired instead of a password. There is more guidance and advice around this choice on enabling advanced monitoring for Azure Flexible Server documentation page.

Once set up, Redgate Monitor will begin collecting comprehensive diagnostic data, which you can review on the estate dashboard as usual, alongside all your other servers:

What’s next for monitoring PostgreSQL

Now that monitoring for Azure PostgreSQL Flexible Server has moved out of preview, we’re actively gathering customer feedback and making refinements, so please get in touch with any feedback and suggestions!

Alongside this, we’re currently working on a range of PostgreSQL monitoring enhancements, including better support for monitoring environments that use physical streaming replication, along with improving features like current activity monitoring to provide increased visibility into running queries and database workload.