Overview

We are thrilled to announce that Azure Arc-enabled servers now have the capability to automatically identify PostgreSQL installations. This new feature allows you to use Azure-based management for overseeing your servers running PostgreSQL at-scale.

What has changed?

The Azure Connected Machine agent captures metadata about the connected machine after registration with Azure Arc-enabled servers. This instance metadata now includes the presence of PostgreSQL.

How to use it?

The instance metadata collected is available as attributes which can be queried at scale using Azure Resource Graph. The presence of PostgreSQL can be queried using the  properties.detectedProperties.pgsqldiscovered.

Navigate to the Machines blade under Azure Arc resources. Click Open query to open an Azure Resource Graph query. Add the column properties.detectedProperties.pgsqldiscovered to the output. Modify and customize the query further as needed with any required filtering, grouping and sorting.

Call To Action

Use Azure Resource Graph queries today to view your Azure Arc-enabled servers with PostgreSQL installations.

•  Connected Machine agent overview
• Reporting and querying with Azure Resource Graph (ARG)