nagios监控postgresql

港控/mmm° 2022-08-18 14:22 232阅读 0赞

**1.在被监控端安装nagios的nrpe插件**

**2.在被监控端安装check\_postgres**

> http://bucardo.org/downloads/check\_postgres-2.22.0.tar.gz  
>

**3.在被监控端配置nrpe.cfg，并起动nrpe服务**

> vim /etc/nagios/nrpe.cfg  
> 
> 
>   
> 
> 
> log\_facility=daemon  
> pid\_file=/var/run/nrpe/nrpe.pid  
> server\_port=5666  
> nrpe\_user=nrpe  
> nrpe\_group=nrpe  
> allowed\_hosts=127.0.0.1,\*\*\*.\*\*\*.\*\*\*.\*\*\*.\*\*\*\#(必须添加监控端ip)  
> dont\_blame\_nrpe=0  
> allow\_bash\_command\_substitution=0  
> debug=0  
> command\_timeout=60  
> connection\_timeout=300  
>   
> command\[check\_users\]=/usr/lib64/nagios/plugins/check\_users -w 5 -c 10  
> command\[check\_load\]=/usr/lib64/nagios/plugins/check\_load -w 15,10,5 -c 30,25,20  
> command\[check\_root\]=/usr/lib64/nagios/plugins/check\_disk -w 20% -c 10% -p /  
> command\[check\_mnt\]=/usr/lib64/nagios/plugins/check\_disk -w 20% -c 10% -p /dev/xvdb1  
> command\[check\_mnt1\]=/usr/lib64/nagios/plugins/check\_disk -w 20% -c 10% -p /dev/xvdc1  
> command\[check\_zombie\_procs\]=/usr/lib64/nagios/plugins/check\_procs -w 5 -c 10 -s Z  
> command\[check\_total\_procs\]=/usr/lib64/nagios/plugins/check\_procs -w 150 -c 200  
> command\[check\_db\_disk\]=/usr/lib/nagios/plugins/contrib/check\_diskio -d /dev/xvdc1 -w 30 -c 70 --uom=byte --factor=M -t 30  
> command\[check\_xlog\_disk\]=/usr/lib/nagios/plugins/contrib/check\_diskio -d /dev/xvdb1 -w 30 -c 70 --uom=byte --factor=M -t 30  
>   
> command\[check\_arch\]=/usr/bin/check\_postgres\_archive\_ready --output=nagios -db postgres -u postgres -w 10 -c 20  
> command\[check\_freeze\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db postgres -u postgres --action=autovac\_freeze -w 90% -c 95% --exclude=template1,template0  
> command\[check\_conns\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db postgres -u postgres --action=backends -w=800 -c=1500  
> command\[check\_bloat\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db cd02,cd03\_wk -u postgres --action=bloat -w="200M" -c="500M" --perflimit=10  
> command\[check\_checkpoint\]=/usr/bin/check\_postgres\_checkpoint --output=nagios --datadir=$PGHOME  -w 300 -c 600  
> command\[check\_commitratio\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db postgres -u postgres --action=commitratio -w 90% -c 80%  
> command\[check\_dbsize\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db cd02,cd03\_wk -u postgres --action=database\_size -w 1T -c 2T --exclude=template1,template0,postgres,pgbench  
> command\[check\_hitratio\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db postgres,cd02,cd03\_wk -u postgres --action=hitratio -w 90% -c 80% --exclude=template1,template0,pgbench  
> command\[check\_relsize\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -db postgres,cd02,cd03\_wk -u postgres --action=relation\_size -w 10G -c 20G --perflimit=5  --exclude=template1,template0,pgbench  
> command\[check\_autovacuum\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db postgres,cd02,cd03\_wk --action=last\_autovacuum --perflimit=3 -w '3d' -c '7d'  --exclude=template1,template0,pgbench  
> command\[check\_autoanalyze\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db postgres,cd02,cd03\_wk --action=last\_autoanalyze --perflimit=3 -w '3d' -c '7d'  --exclude=template1,template0,pgbench  
> command\[check\_locks\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db postgres,cd02,cd03\_wk --action=locks -w 100 -c total=250:waiting=5:exclusive=20  --exclude=template1,template0,pgbench  
> command\[check\_query\_time\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db cd02,cd03\_wk --action=query\_time -w '10s'  
> command\[check\_seq1\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db cd02 --action=sequence -w 90%  
> command\[check\_txnidle\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db cd02,cd03\_wk --action=txn\_idle -w "1 for 100s" -c "3 for 100s"  
> command\[check\_xlogs\]=/usr/bin/check\_postgres.pl --output=nagios -H 127.0.0.1 -p 5432 -u postgres --db postgres --action=wal\_files -w 180 -c 200  
>   
> include\_dir=/etc/nrpe.d/

**4.在监控端安装nagios**（**监控端也要安装**nrpe插件，但是不用起动nrpe）

**5.在监控端添加监控命令**

> define command\{  
>         command\_name check\_nrpe  
>         command\_line $USER1$/check\_nrpe -H $HOSTADDRESS$ -c $ARG1$ -t 60  
>         \}  
>

**6.在监控端添加监控项配置**

> vim /etc/nagios/server/db1.cfg  
> 
> 
> define service\{
> 
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>     service\_description             SSH  
>     check\_command            check\_ssh  
>         \}  
>   
>   
>   
> define service\{  
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>         service\_description             Root Partition  
>         check\_command                   check\_nrpe!check\_root  
>         \}  
>   
> define service\{  
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>         service\_description             Current Load  
>         check\_command                   check\_nrpe!check\_load  
>         \}  
>   
> define service\{  
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>         service\_description             mnt hd01  
>         check\_command                   check\_nrpe!check\_mnt  
>         \}  
>   
> define service\{  
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>         service\_description             mnt hd02  
>         check\_command                   check\_nrpe!check\_mnt1  
>         \}  
> ;check\_db1 stauts  
> define service\{  
>         use                             generic-service         ; Name of service template to use  
>         host\_name                       db1  
>         service\_description             check\_arch  
>         check\_command                   check\_nrpe!check\_arch  
>         \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_freeze  
>   check\_command check\_nrpe!check\_freeze  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_conns  
>   check\_command check\_nrpe!check\_conns  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_bloat  
>   check\_command check\_nrpe!check\_bloat  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_commitratio  
>   check\_command check\_nrpe!check\_commitratio  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_dbsize  
>   check\_command check\_nrpe!check\_dbsize  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_hitratio  
>   check\_command check\_nrpe!check\_hitratio  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_relsize  
>   check\_command check\_nrpe!check\_relsize  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_locks  
>   check\_command check\_nrpe!check\_locks  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_query\_time  
>   check\_command check\_nrpe!check\_query\_time  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_seq1  
>   check\_command check\_nrpe!check\_seq1  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_txnidle  
>   check\_command check\_nrpe!check\_txnidle  
> \}  
> define service\{  
>   use generic-service  
>   host\_name db1  
>   service\_description check\_xlogs  
>   check\_command check\_nrpe!check\_xlogs  
> \}  
>   
> define service\{  
>   use generic-service,srv-pnp  
>   host\_name db1  
>   service\_description check\_disk\_db  
>   check\_command check\_nrpe!check\_db\_disk  
> \}  
>   
> define service\{  
>   use generic-service,srv-pnp  
>   host\_name db1  
>   service\_description check\_disk\_xlog  
>   check\_command check\_nrpe!check\_xlog\_disk  
> 
> 
> \}

**7.配置nagios.cfg文件，主要是加载/etc/nagios/server/db1.cfg文件**

> cfg\_file=/etc/nagios/objects/commands.cfg  
> cfg\_file=/etc/nagios/objects/contacts.cfg  
> cfg\_file=/etc/nagios/objects/timeperiods.cfg  
> cfg\_file=/etc/nagios/objects/templates.cfg  
> \# Definitions for monitoring the local (Linux) host  
> cfg\_file=/etc/nagios/server/db1.cfg

**8.启动nagios**

> service nagios start  
>