Performing a Query on a PostgreSQL Database

This section details the various connection settings available for performing queries on PostgreSQL database server.

To configure a connection to a PostgreSQL database server

1.	In the PATROL Console, right-click the Host or Monitor Group icon and select KM Commands > New > Monitor...

2.	Select Database Query: PostgreSQL from the drop-down list and click Next.

Analyzing_Database_Query_PostgreSQL_1

Performing a Query on a PostgreSQL Database - PostgreSQL Connection Information

3.	Define the Connection Information to the PostgreSQL database server:

▪	Database name: Enter the name of the database.

▪	Port number: Enter the port to be used to access the PostgreSQL database (Default: port 5432).

These settings apply to all PostgreSQL connections defined on the host.

4.	Click Next.

Analyzing_Database_Query_PostgreSQL_2

Performing a Query on a PostgreSQL Database - PostgreSQL Query Information

5.	Define the Query Information to the PostgreSQL database server:

•	Credentials: Select the type of credentials that you want to use:

•	System Credentials (default): Uses the credentials previously specified when creating the Host.

•	Add new credentials...: Lets you set new specific credentials.

▪	SQL Query: Enter the SQL query you wish to perform.

▪	Timeout: Specify the time in seconds after which the query will be stopped (Default: 30 seconds). If the query times out, the Status parameter will be set to 2 (Failed) and an alarm will be triggered.

▪

Report execution errors in Group's CollectionErrorCount: Select this option to have the CollectionErrorCount parameter of the Group reflect possible alerts triggered upon the query execution. The CollectionErrorCount parameter of the Group reports on the collection errors of any Monitor associated to the group, for which this option is available and selected, providing a global view of the collection errors for the whole Group.

6.	Click Next.

7.	Configure the Monitor settings.

8.	Click Finish. The corresponding Database Query instance (Database Query: <Display Name>) is created in the PATROL Console. The collected parameters for Database Query Monitors are listed in the SEN_MS_DBQUERY chapter.