The Aria Operations PostgreSQL Management Pack version 9.1.0 doesn't discover databases other than the default Postgres database.

Products

• VMware Aria Suite

Issue/Introduction

This article has the purpose of informing our customers there is a known issue in the Aria Operations PostgreSQL Management Pack version 9.1.0.

The Aria Operations for PostgreSQL Management Pack version 9.1.0,  "Postgres" database is only monitored, regardless of what is entered in the adapter configuration.

 

Environment

Aria Operations 8.17.x

Aria Operations 8.18.x

Aria Operations for PostgreSQL Management Pack version 9.1.0

 

Resolution

Upgrade the  Aria Operations for PostgreSQL Management Pack version 9.2.0

1- Check compatibility of Aria Operations with the Management pack Product Interoperability Matrix

2-  Download this version on the VMware marketplace Aria Operations Management Pack for PostgreSQL

3- Take Aria Operations off line via the admin interface.

4-  When all the nodes show offline, create snapshots for all the nodes without memory.

5- Bring the cluster online

6-Upgrade the  Management Pack

6.1 Log in to the VMware Aria Operations user interface with admin privileges.

6.2  From the left menu, click Data Sources > Integrations.

6.3 Go to the Repository tab in the right pane, and then click Add.

6.4 Browse to locate the temporary folder and select the PAK file.

6.5 Select the Install the PAK file even if it is already installed check box.

This selection reloads the PAK file but retains the custom preferences of the user. Also, this selection does not overwrite or update the solution alerts, symptoms, recommendations, and policies.

6.6 Select the Reset Default Content, overwriting to a newer version provided by this update check box.

This selection reloads the PAK file and overwrites the existing solution alerts, symptoms, recommendations, and policies with newer versions provided with the current PAK file.

6.7 Click Upload.

The upload might take several minutes.

6.8 Read and accept the EULA, and then click Next.

6.9 When the upgrade is complete, click Finish.

6.10 On the Manage Solutions page, click Test Connection to validate the connection.

NOTE:

We advise upgrade to the latest version of Aria Operations Management Packs, as they are always the newest fixes added to the most recent versions