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).

Note:

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.