zabbix 报警:PostgreSQL Backend connections are exhausted on HH-openshift-master
报警内容:PostgreSQL Backend connections are exhausted on HH-openshift-master
报警等级:严重
解决方法:增加数据库的后端连接
查询:
postgres=# show max_connections;(允许最大连接数)
max_connections
-----------------
100
(1 row)
postgres=#
postgres=# select count(1) from pg_stat_activity;(已使用连接数)
count
-------
98
(1 row)
更改:
[root@master ~]# vim /mnt/postgresql/postgresql.conf
重启:
[root@master ~]# systemctl restart postgresql-9.6.service
检查:
bash-4.2$ psql
psql (9.6.10)
Type "help" for help.
postgres=#
postgres=# show max_connections;
max_connections
-----------------
3000
(1 row)