Martin Čaj 0e8bcf
profile:
Martin Čaj 0e8bcf
  monitoring:
Martin Čaj 0e8bcf
    checks:
Martin Čaj 0e8bcf
      check_postgres_backends: "/usr/lib/nagios/plugins/check_postgres_backends --warning='-50' --critical='-10'"
Martin Čaj 0e8bcf
      check_postgres_bloat: "/usr/lib/nagios/plugins/check_postgres_bloat --db=mb_opensuse2 --warning='3000 M' --critical='5000 M'"
Martin Čaj 0e8bcf
      check_postgres_last_autovacuum: "/usr/lib/nagios/plugins/check_postgres_last_autovacuum --warning='7d' --critical='14d' --db=mb_opensuse2"
Martin Čaj 0e8bcf
      check_postgres_locks: "/usr/lib/nagios/plugins/check_postgres_locks --warning='60' --critical='total=50:waiting=1:exclusive=20'"
Martin Čaj 0e8bcf
      check_postgres_wal_files: "/usr/lib/nagios/plugins/check_postgres_wal_files --critical='120' --warning='100'"
Martin Čaj 0e8bcf
Christian Boltz 1c11f2
    {% set osrelease = salt['grains.get']('osrelease') %}
Christian Boltz 1c11f2
    {% if osrelease == '15.0' %}
Christian Boltz 1c11f2
    check_zypper:
Christian Boltz 1c11f2
      whitelist:
Christian Boltz 1c11f2
        # packages from server:database:postgresql
Christian Boltz 1c11f2
        - libpq5
Christian Boltz 1c11f2
        - postgresql
Christian Boltz 1c11f2
        - postgresql-contrib
Christian Boltz 1c11f2
        - postgresql-llvmjit
Christian Boltz 1c11f2
        - postgresql-server
Christian Boltz 1c11f2
        - postgresql11
Christian Boltz 1c11f2
        - postgresql11-contrib
Christian Boltz 1c11f2
        - postgresql11-ip4r
Christian Boltz 1c11f2
        - postgresql11-llvmjit
Christian Boltz 1c11f2
        - postgresql11-repmgr
Christian Boltz 1c11f2
        - postgresql11-server
Christian Boltz 1c11f2
        - repmgr
Christian Boltz 1c11f2
    {% endif %}
Christian Boltz 1c11f2
Martin Čaj 0e8bcf
zypper:
Martin Čaj 0e8bcf
  packages:
Martin Čaj 0e8bcf
    postgresql: {}
Martin Čaj 0e8bcf
    postgresql-llvmjit: {}
Martin Čaj 0e8bcf
    postgresql-contrib: {}
Martin Čaj 0e8bcf
    postgresql-server: {}
Martin Čaj 0e8bcf
    monitoring-plugins-postgres: {}
Christian Boltz f97ce0
  repositories:
Christian Boltz f97ce0
    server_database_postgresql:
Christian Boltz f97ce0
      baseurl: http://download.infra.opensuse.org/repositories/server:/database:/postgresql/openSUSE_Leap_{{ salt['grains.get']('osrelease') }}/
Christian Boltz f97ce0
      priority: 99
Christian Boltz f97ce0
      refresh: True