Redgate Monitor 14

Adding PostgreSQL on Azure Flexible Server

Additional configuration required

Make sure you have prepared PostgreSQL for monitoring before adding a PostgreSQL instance to Redgate Monitor. 

This page explains how to add an Azure Flexible Server PostgreSQL to Redgate Monitor. To monitor Azure Flexible metrics via the Azure API see enabling advanced monitoring for Azure Flexible server.

For details of the metrics and alerts available for Azure Flexible PostgreSQL, please see: PostgreSQL on Azure Flexible metrics and alerts.

Ensure that the Azure Flexible PostgreSQL instance is reachable by the machine running the Base Monitor. Check the different ways you can modify Azure Flexible' security group in this Azure guide.
  1. Go to Configuration → Monitored servers → Add → PostgreSQL


  2. Select Azure Flexible Server as the environment
  3. In the Endpoint name field, enter the endpoint for the instance provided by Azure, this will typically end with ".*.postgres.database.azure.com". Please check the screenshot below to see where the endpoint name is (server name in this case)
  4. Enter the port in the Port field. This is typically the default of 5432  for PostgreSQL.
  5. Enter the username and password. You should use the Monitor user you have created when following the Preparing PostgreSQL for monitoring guide.
  6. Optionally, enter the "Login database" if you are not using the same database name as your username.
  7. You can select a group where the instance will be added, select "Uncategorized" if you don't want to put it in any particular group.
  8. For capturing machine metrics for your Azure Flexible PostgreSQL instance, you must switch on "Enable advanced monitoring" and provide authentication method.
    1. For information on how to set up advanced monitoring, see our dedicated documentation on enabling advanced monitoring for Azure Flexible server.

Didn't find what you were looking for?