Werk #7700: mk_postgres: Fixed several problems

Component Checks & agents
Title mk_postgres: Fixed several problems
Date May 31, 2019
Checkmk Edition Checkmk Raw (CRE)
Checkmk Version 1.5.0p17 1.6.0b1
Level Trivial Change
Class Bug Fix
Compatibility Compatible - no manual interaction needed

Originally the version of the client tools was taken, but what really matters is the version of the server. Terminate the script, if the server can not be queried.

In postgresql 9.2 the column state was introduced, which has to be queried to find the state of the sessions. The column state can be NULL.

Here the order of the columns did not match with what the server side expects, with the result, that there was never any active connection shown in the web-gui.

To the list of all Werks