Before installing and configuring the Management Pack, ensure your system meets the following requirements:
|vRealize Operations Requirements||PostgreSQL Requirements|
|Version(s)||vRealize Operations v6.3+ (Enterprise edition only)||PostgreSQL 9.4+|
|Connection||vROps hostname or IP address||
IP address or hostname of PostgreSQL instance
Default Port: 5432 (TCP)
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).