Before installing and configuring the Management Pack, ensure your system meets the following requirements.
For compatibility between products, please refer to:
vRealize Operations Interoperability for PostgreSQL
-OR-
Third Party Solution Interoperability for PostgreSQL
vRealize Operations Requirements |
PostgreSQL Requirements |
|
---|---|---|
Connection |
vROps hostname or IP address |
IP address or hostname of PostgreSQL instance Default Port: 5432 (TCP) Database name
Note:
By default, the Management Pack will connect to ‘pg_ database’ and retrieve available databases through it. If another database is specified when adding an adapter instance, it will connect to that database only. |
Credentials |
vROps User Name/Password with access to vRealize Suite API is required |
PostgreSQL User Name/Password The Management Pack requires a least-privileged user (LPU) account of read-only*. For details on creating an LPU, see: Configuring Database Permissions and the Least-Privileged User (PostgreSQL).
Note:
*NOTE: Tablespace and query data are not returned for PostgreSQL read-only users. Assigning the monitoring user/role a “super user” attribute will correct this limitation. Alternatively, using our defined LPU script will allow you to bypass assigning the "super user" attribute. See: Configuring Database Permissions and the Least-Privileged User (PostgreSQL). |
Prior to configuring an adapter instance for the Management Pack, ensure the required PostgreSQL views, tables, and functions are added for resources being monitored. See: Configuring Database Permissions and the Least-Privileged User (PostgreSQL) for more information.