Azure PostgreSQL

Collect Azure PostgreSQL Metrics

Configuration¶

Install Func¶

It is recommended to activate the TrueWatch integration - extension - DataFlux Func (Automata): all prerequisites are automatically installed. Please proceed with the script installation.

If you are deploying Func manually, refer to Manual Func Deployment

Install Script¶

Note: Please prepare the required Azure application registration information in advance and assign the Monitoring Reader role to the application registration.

1. Log in to the Func console, click on 【Script Market】, enter the TrueWatch Script Market, and search for integration_azure_postgresql_flexible_server

2. Click 【Install】, then input the corresponding parameters: Azure Tenant ID, Azure Client ID, Azure Client Secret Value, Subscriptions

3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup scripts.

4. After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute once without waiting for the scheduled time. Wait a moment, then you can check the execution task records and corresponding logs.

Verification¶

1. In 「Manage / Automatic Trigger Configuration」, confirm if the corresponding task has the automatic trigger configuration, and check the task records and logs for any exceptions.
2. In TrueWatch, check if the asset information exists in 「Infrastructure - Resource Catalog」.
3. In TrueWatch, check if the corresponding monitoring data is available in 「Metrics」.

Metrics¶

Collect Azure PostgreSQL Metrics, more metrics can be collected through configuration Microsoft.DBforPostgreSQL/flexibleServers Supported Metrics