Page tree

Before you can begin using the PostgreSQL KM, you must configure a monitoring environment.

You can use the information in this topic to configure the PostgreSQL environment for monitoring in the PATROL console.

This information includes:

Before you begin

You must have installed and loaded PATROL for PostgreSQL.

The operating system user account must have read and execute permissions for the Java Home directory, and full access to the ../Patrol3/pgrkm directory.

To register a PostgreSQL environment

Choose PostgreSQL > KM Commands > Register PostgreSQL environment.

In the Register PostgreSQL environment dialog box, enter the following information:

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

Remote SSH port
(UNIX only)
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 .