Can you monitor a PostgreSQL Database?

Document ID : KB000034684
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How can we monitor the Postgresql database?

Answer:

You can use the sql_response probe to monitor a Postgresql database. You can add postgresql as successfully queried through an ODBC connection using the Postgresql ODBC driver.

The Postgres database driver can be downloaded from the following location:

http://wwwmaster.postgresql.org/download/mirrors-ftp/odbc/versions/msi/psqlodbc_08_03_0400.zip 

Additional Information:

Documentation for the sql_response probe can be found here:

https://docops.ca.com/ca-unified-infrastructure-management-probes/en/alphabetical-probe-articles/sql_response-sql-server-response-monitoring

 

Also see:

 TEC000002389