Werk #11142: PostgreSQL: Differentiate idle from active connections

Component Checks & agents
Title PostgreSQL: Differentiate idle from active connections
Date Jul 13, 2020
Checkmk Edition Checkmk Raw (CRE)
Checkmk Version 2.0.0i1
Level Trivial Change
Class New Feature
Compatibility Incompatible - Manual interaction might be required

Previously, the agent plugin "mk_postgres" and the check plugin "postgres_connections" were not differentiating between "idle" and "active" connections. With this werk, the data to differentiate those states is obtained and evaluated accordingly.

The WATO rule "Database Connections (PostgreSQL)" (renamed from "Database Connections (PostgreSQL/MongoDB)") has now a dedicated option for setting the levels for "active" and "idle" connections. In case the rule was used previously, the default connection type for PostgreSQL will be "active" as the old agent was excluding "idle" connections.

Note: As this WATO rule was applicable as well for MongoDB, this change will be incompatible to previously existing MongoDB rules set with "Database Connections (PostgreSQL/MongoDB)". If this is applicable for your setup, perform the following steps:

  • If you're monitoring both PostgreSQL and MongoDB: keep the old rule "Database Connections (PostgreSQL/MongoDB)" before updating to this werk.
  • If you're monitoring MongoDB only: delete the old rule "Database Connections (PostgreSQL/MongoDB)" before updating to this werk
  • Create a new rule with your previous settings for MongoDB with the new rule "Database Connections (MongoDB)"

To the list of all Werks