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. Modification requires a server restart |
| 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. Modification requires a server restart |
| 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. Modification requires a server restart |
| 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. Modification requires a server restart |
| 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. Modification requires a server restart |
| 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. Modification requires a server restart |
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}] ...