check_mk pg_replication_check

pg_replication_check

#!/bin/bash

Q="select now() - pg_last_xact_replay_timestamp() < interval '10 seconds',extract (epoch from now() - pg_last_xact_replay_timestamp()) ;"

RES=($(echo ${Q} | /usr/bin/psql -tA -Upostgres | tr '|' " "))
STATUS=2
if [ ${RES[0]} == 't' ];then
    STATUS=0
    STATUSTEXT="OK"
else
    STATUSTEXT="CRITICAL"
fi

echo "$STATUS postgres_replication_check delay=${RES[1]};5;10 $STATUSTEXT replication delay is ${RES[1]}"