Azure PostgreSQL

Collect Azure PostgreSQL Metrics data

Configuration¶

Install Func¶

It is recommended to enable the Guance integration - extension - DataFlux Func (Automata): all prerequisites will be automatically installed. Please continue with the script installation.

If you deploy Func yourself, refer to Self-deployed Func

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 official script market, and search for guance_azure_postgresql_flexible_server
2. After clicking 【Install】, 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 a Startup script set and automatically configure the corresponding startup script.
4. After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to run it immediately without waiting for the scheduled time. Wait a moment, then check the execution task records and corresponding logs.

Verification¶

1. In 「Manage / Automatic Trigger Configuration」, confirm that the corresponding task has the appropriate automatic trigger configuration. You can also view the task records and logs to check for any anomalies.
2. In Guance, under 「Infrastructure - Resource Catalog」, check if asset information exists.
3. In Guance, under 「Metrics」, check if there are corresponding monitoring data.

Metrics¶

Collect Azure PostgreSQL Metrics. More metrics can be collected via configuration. Refer to Microsoft.DBforPostgreSQL/flexibleServers Supported Metrics