Postgres Monitoring Databases contain the configuration information used by the Metrics Engine to connect to a Postgres RDBMS.
Postgres Monitoring Databases provide the information used to connect to a specific RDBMS instance on a specified Postgres RDBMS server.
↓Parent Component
↓Properties
↓dsconfig Usage
The Postgres Monitoring Database component inherits from the Monitoring Database
The properties supported by this managed object are as follows:
| Basic Properties: | Advanced Properties: |
|---|---|
| ↓ database-name | None |
| ↓ server-host-name | |
| ↓ server-port | |
| ↓ user-name | |
| ↓ password | |
| ↓ max-db-connections |
| Description | The name of the database instance on the RDBMS server. |
| Default Value | unboundid |
| Allowed Values | A string |
| Multi-Valued | No |
| Required | Yes |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
| Description | The host name of the database server. |
| Default Value | localhost |
| Allowed Values | A string |
| Multi-Valued | No |
| Required | Yes |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
| Description | The port number where the database server listens for requests. |
| Default Value | 5432 |
| Allowed Values | An integer value. Lower limit is 1. Upper limit is 65535 . |
| Multi-Valued | No |
| Required | Yes |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
| Description | The name of the login account to use when connecting to the database server. This name will also be used as the DBMS 'schema' name, so changing it after the DBMS has been created means you also need to rename the DBMS schema, or create a new one with the new name. |
| Default Value | unboundid |
| Allowed Values | A string |
| Multi-Valued | No |
| Required | Yes |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
| Description | The login password for the specified user name. |
| Default Value | password |
| Allowed Values | A string |
| Multi-Valued | No |
| Required | Yes |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
| Description | Maximum number of concurrent connections to the DBMS. The Postgres DBMS has a maximum number of concurrent JDBC connections it will allow from all clients. This value limits the total number of concurrent JDBC connections the Metrics Engine will use. The lower value is constrained to ensure the non-optional processing of the Metrics Engine is not blocked waiting for JDBC connections. |
| Default Value | 20 |
| Allowed Values | An integer value. Lower limit is 6. Upper limit is 50 . |
| Multi-Valued | No |
| Required | No |
| Admin Action Required | The Metrics Engine must be restarted for changes to this setting to take effect. This modification requires that you manually restart the server for the change to take effect |
To view the Monitoring Database configuration:
dsconfig get-monitoring-database-prop
[--tab-delimited]
[--script-friendly]
[--property {propertyName}] ...
To update the Monitoring Database configuration:
dsconfig set-monitoring-database-prop
(--set|--add|--remove) {propertyName}:{propertyValue}
[(--set|--add|--remove) {propertyName}:{propertyValue}] ...