Werk #7700: mk_postgres: Fixed several problems
| Komponente | Checks & agents |
| Titel | mk_postgres: Fixed several problems |
| Datum | 31.05.2019 |
| Checkmk Edition | Checkmk Raw (CRE) |
| Checkmk-Version | 1.5.0p17 1.6.0b1 |
| Level | Kleine Änderung |
| Klasse | Bugfix |
| Kompatibilität | Kompatibel - benötigt kein manuelles Eingreifen |
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.
