当前位置: 代码迷 >> 综合 >> zabbix 报警:PostgreSQL Backend connections are exhausted on HH-openshift-master
  详细解决方案

zabbix 报警:PostgreSQL Backend connections are exhausted on HH-openshift-master

热度:88   发布时间:2023-12-01 16:51:42.0

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)

  相关解决方案