Registering a PostgreSQL KM environment
To register a PostgreSQL environment
Choose PostgreSQL > KM Commands > Register PostgreSQL environment.
In the Register PostgreSQL environment dialog box, enter the following information:
Field | Description |
|---|---|
Environment name | Enter a unique environment name for monitoring the PostgreSQL database. A container will be created with the environment name. This environment will hold all the PostgreSQL instances. Note: The name cannot include blank spaces or any of the following special characters: # $ \ ' | ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * / |
PostgreSQL Connection details | |
PostgreSQL host | Enter the monitored PostgreSQL host name or the IP address. |
PostgreSQL Port | Enter the port number for connecting to the PostgreSQL database. |
PostgreSQL user | Enter the username used to connect to the PostgreSQL database. Note: To monitor table spaces in the PostgreSQL database, the user must have a superuser role. |
PostgreSQL Password | Enter the user password to connect to the PostgreSQL database. |
PostgreSQL database name | Enter a name for the monitored PostgreSQL database. If this field is left blank, the user name is used as the database name. |
Remote OS Connection details | |
Remote OS type | If the database is on a local host, select N/A and disregard the remaining remote host connection details. If the database is on a remote host, select the host's operating system. |
User Name | The user name and password for the remote OS host. |
Password | |
Remote SSH port | If the PostgreSQL database uses a UNIX operating system, enter the SSH port number. The default port number is 22. |
Java Collector settings | |
Java home | Enter the Java home location on the PATROL agent host. For example, if the JAVA location on the agent host is /usr/java/jdk1.8.0_45/jre/bin/java path, enter /usr/java/jdk1.8.0_45/jre in this field. |
JVM arguments | Enter the optional Java Virtual Machine arguments for the Java collector. |
Click OK to add this to the environment configurations list. This environment is displayed in the PostgreSQL hierarchy.
Click Cancel to exit without saving any changes.
You can continue to add more environments for monitoring.
To set the debug option
In the PATROL console hierarchy, select the PostgreSQL > KM Commands > KM Administration>Define Debug Settings.
If you select On and Accept, each PostgreSQL environment is automatically enabled to collect PSL and Java logs.
If this option is Off, you can enable logging for a specific environment by enabling the debug option on the environment level .