From b5305b5cad5cbb0a2c072b29f2d4dc05126c39d4 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Isma=C3=ABl=20Bouya?= <ismael.bouya@normalesup.org>
Date: Sun, 8 Jul 2018 21:51:30 +0200
Subject: Add postgresql monitoring

---
 .../files/monitoring/check_postgres_replication    | 35 ++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 modules/profile/files/monitoring/check_postgres_replication

(limited to 'modules/profile/files/monitoring/check_postgres_replication')

diff --git a/modules/profile/files/monitoring/check_postgres_replication b/modules/profile/files/monitoring/check_postgres_replication
new file mode 100644
index 0000000..163c68a
--- /dev/null
+++ b/modules/profile/files/monitoring/check_postgres_replication
@@ -0,0 +1,35 @@
+#!/bin/bash
+ 
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+  
+user=$1
+host=$2
+port=$3
+
+lag=$(psql -h $host -p $port -A -t -c "SELECT COALESCE(EXTRACT(EPOCH FROM replay_lag),0) FROM pg_stat_replication WHERE usename='$user'" 2>/dev/null)
+exit_code=$?
+
+if [[ $exit_code -ne 0 ]]; then
+  echo "UNKNOWN:Impossible to run psql command"
+  exit $STATE_UNKNOWN
+elif [[ -z "$lag" ]]; then
+  echo "UNKNOWN:No replication found for $user"
+  exit $STATE_UNKNOWN
+else
+  output="Replication lag for $user is ${lag}s"
+  LC_ALL=C lag=$(printf "%.*f" 0 $lag)
+
+  if [[ $lag -lt 5 ]]; then
+    echo "OK:$output"
+    exit $STATE_OK
+  elif [[ $lag -lt 10 ]]; then
+    echo "WARNING:$output"
+    exit $STATE_WARNING
+  else
+    echo "CRITICAL:$output"
+    exit $STATE_CRITICAL
+  fi
+fi
-- 
cgit v1.2.3


From a0df248a2be61557b8a67c3d6e4df24dc3e7843e Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Isma=C3=ABl=20Bouya?= <ismael.bouya@normalesup.org>
Date: Tue, 10 Jul 2018 12:36:52 +0200
Subject: Add monitoring for etherpad

---
 modules/profile/files/monitoring/check_postgres_replication | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'modules/profile/files/monitoring/check_postgres_replication')

diff --git a/modules/profile/files/monitoring/check_postgres_replication b/modules/profile/files/monitoring/check_postgres_replication
index 163c68a..a550077 100644
--- a/modules/profile/files/monitoring/check_postgres_replication
+++ b/modules/profile/files/monitoring/check_postgres_replication
@@ -13,23 +13,23 @@ lag=$(psql -h $host -p $port -A -t -c "SELECT COALESCE(EXTRACT(EPOCH FROM replay
 exit_code=$?
 
 if [[ $exit_code -ne 0 ]]; then
-  echo "UNKNOWN:Impossible to run psql command"
+  echo "UNKNOWN - Impossible to run psql command"
   exit $STATE_UNKNOWN
 elif [[ -z "$lag" ]]; then
-  echo "UNKNOWN:No replication found for $user"
+  echo "UNKNOWN - No replication found for $user"
   exit $STATE_UNKNOWN
 else
   output="Replication lag for $user is ${lag}s"
   LC_ALL=C lag=$(printf "%.*f" 0 $lag)
 
   if [[ $lag -lt 5 ]]; then
-    echo "OK:$output"
+    echo "OK - $output"
     exit $STATE_OK
   elif [[ $lag -lt 10 ]]; then
-    echo "WARNING:$output"
+    echo "WARNING - $output"
     exit $STATE_WARNING
   else
-    echo "CRITICAL:$output"
+    echo "CRITICAL - $output"
     exit $STATE_CRITICAL
   fi
 fi
-- 
cgit v1.2.3