12 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)
15 if [[ $exit_code -ne 0 ]]; then
16 echo "UNKNOWN
- Impossible to run psql
command"
18 elif [[ -z "$lag" ]]; then
19 echo "UNKNOWN
- No replication found
for $user"
22 output="Replication lag
for $user is
${lag}s
"
23 LC_ALL=C lag=$(printf "%.*f" 0 $lag)
25 if [[ $lag -lt 5 ]]; then
26 echo "OK
- $output | time=${lag}s
;5;10;0;"
28 elif [[ $lag -lt 10 ]]; then
29 echo "WARNING
- $output | time=${lag}s
;5;10;0;"
32 echo "CRITICAL
- $output | time=${lag}s
;5;10;0;"