Use nagios monitor PostgreSQL archive status
发布时间：2020-12-13 17:44:57 所属栏目：百科 来源：网络整理
导读：PostgreSQL Archived in the Cloud http://blog.163.com/digoal@126/blog/static/163877040201152321027994/ 关于归档状态的监控采用nagios来搞定，如下是一个archive_command输出的文件内容: cat /tmp/pgarchive.nagios_5432 0 status=0,success.remote 201
PostgreSQL Archived in the Cloud
http://blog.163.com/digoal@126/blog/static/163877040201152321027994/
关于归档状态的监控采用nagios来搞定，如下是一个archive_command输出的文件内容:
cat /tmp/pgarchive.nagios_5432
0
status=0,success.remote
2011-07-0113:09:14
第一行是归档状态，在归档命令里面定义。后面的是详细信息。根据第一行的值判断应该返回给NAGIOS什么值。
nagios脚本的返回值0表示success,1表示warnning,2表示critical,3表示unknown.
# 下面是归档命令里面定义的返回值
# NAGIOS返回值 0 status=0,success.remote
# NAGIOS返回值 1 status=1,success.local
# NAGIOS返回值 1 status=2,handwork_pause_can_continue_at_this_point.remote and local
# NAGIOS返回值 2 status=2,failed_can_continue_at_this_point.remote and local
# NAGIOS返回值 2 status=3,handwork_stop_can_not_continue_at_this_point.remote and local
# NAGIOS返回值 2 status=4,switch_check_unknown_can_continue_at_this_point.remote and local
# NAGIOS返回值 2 错误消息
# 所以可以写一个脚本供nrpe调用.
[root@db-192-168-173-66 ~]# cat /usr/local/nagios/libexec/check_postgresql
#!/bin/bash
if [ $# -ne 2 ]; then
echo -e "Usage : $prog $1 $2 "
exit 2
fi
DB_PORT=$2
nohup echo -e "q"|telnet -e "q" 127.0.0.1 $DB_PORT >/dev/null 2>&1
if [ $? -ne 0 ]; then
echo -e "PostgreSQL not run in this node"
exit 0
fi
check_archive()
{
test -f /tmp/pgarchive.nagios_$DB_PORT
if [ $? -ne 0 ]; then
RESULT=2
MESSAGE="`date +%F%T`n/tmp/pgarchive.nagios_$DB_PORT not exist."
echo -e $MESSAGE
return $RESULT
fi
find /tmp/pgarchive.nagios_$DB_PORT -mmin -45|grep "pgarchive.nagios_$DB_PORT"
if [ $? -ne 0 ]; then
RESULT=2
MESSAGE="`date +%F%T`nPostgreSQL archive timeout."
echo -e $MESSAGE
return $RESULT
fi
RESULT=`head -n 1 /tmp/pgarchive.nagios_$DB_PORT`
cat /tmp/pgarchive.nagios_$DB_PORT
return $RESULT
}
# See how we were called.
case "$1" in
check_archive)
check_archive
;;
*)
echo $"Usage: $prog {check_archive} port"
exit 1
esac
# 2011-07-01 by Digoal.Zhou
chmod 555 /usr/local/nagios/libexec/check_postgresql
# 把这个脚本加入到nagios配置文件
vi /usr/local/nagios/etc/nrpe.cfg
添加一条
command[check_postgresql1]=/usr/local/nagios/libexec/check_postgresql check_archive 5432
重启xinetd服务
service xinetd restart
在nagios服务端添加监控项 check_postgresql1
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |