checks/postgres_instances

   1 #!/usr/bin/python
   2 # -*- encoding: utf-8; py-indent-offset: 4 -*-
   3 # +------------------------------------------------------------------+
   4 # |             ____ _               _        __  __ _  __           |
   5 # |            / ___| |__   ___  ___| | __   |  \/  | |/ /           |
   6 # |           | |   | '_ \ / _ \/ __| |/ /   | |\/| | ' /            |
   7 # |           | |___| | | |  __/ (__|   <    | |  | | . \            |
   8 # |            \____|_| |_|\___|\___|_|\_\___|_|  |_|_|\_\           |
   9 # |                                                                  |
  10 # | Copyright Mathias Kettner 2016             mk@mathias-kettner.de |
  11 # +------------------------------------------------------------------+
  12 #
  13 # This file is part of Check_MK.
  14 # The official homepage is at http://mathias-kettner.de/check_mk.
  15 #
  16 # check_mk is free software;  you can redistribute it and/or modify it
  17 # under the  terms of the  GNU General Public License  as published by
  18 # the Free Software Foundation in version 2.  check_mk is  distributed
  19 # in the hope that it will be useful, but WITHOUT ANY WARRANTY;  with-
  20 # out even the implied warranty of  MERCHANTABILITY  or  FITNESS FOR A
  21 # PARTICULAR PURPOSE. See the  GNU General Public License for more de-
  22 # tails. You should have  received  a copy of the  GNU  General Public
  23 # License along with GNU Make; see the file  COPYING.  If  not,  write
  24 # to the Free Software Foundation, Inc., 51 Franklin St,  Fifth Floor,
  25 # Boston, MA 02110-1301 USA.
  26
  27 # single instance without config
  28 # <<<postgres_instances>>>
  29 # [[[postgres]]]
  30 # 3717 /usr/lib/postgresql83/bin/postgres -D /var/lib/pgsql/data
  31
  32 # single instance with config
  33 # <<<postgres_instances>>>
  34 # 9792 /postgres/9.5.5/bin/postgres -D /postgres/CCENTERE
  35
  36 # multi instances with config
  37 # <<<postgres_instances>>>
  38 # 3960 /usr/lib/postgresql91/bin/postgres -D /var/lib/pgsql/bbtdb -p 5433
  39 # 4149 /usr/lib/postgresql91/bin/postgres -D /var/lib/pgsql/conftdb -p 5434
  40 # 16400 /usr/lib/postgresql91/bin/postgres -D /postgres/jiratdb
  41
  42
  43 def parse_postgres_instances(info):
  44     parsed = {}
  45     is_single = False
  46     for line in info:
  47         if line[0].startswith("[[[") and line[0].endswith("]]]"):
  48             db_id = line[0][3:-3]
  49             is_single = True
  50             parsed.setdefault(db_id.upper(), {})
  51
  52         elif len(line) >= 4:
  53             if not is_single:
  54                 db_id = line[3].split("/")[-1]
  55             parsed.update(db_id.upper(), {"pid": line[0]})
  56
  57     return parsed
  58
  59
  60 def check_postgres_instances(item, _no_params, parsed):
  61     pid = parsed.get(item, {}).get("pid")
  62     if pid is not None:
  63         return 0, "Status: running with PID %s" % pid
  64     return 2, "Instance %s not running" % item
  65
  66
  67 check_info['postgres_instances'] = {
  68     'parse_function': parse_postgres_instances,
  69     'inventory_function': discover(),
  70     'check_function': check_postgres_instances,
  71     'service_description': 'PostgreSQL Instance %s',
  72 }