Support for Nagios products and services
https://support.nagios.com/forum/
Code: Select all
max_connections = 100Code: Select all
service postgresql restartAs mentioned, this is occurring on several of our XI servers. One for example has 146 Hosts and 1916 Services. Certainly nothing near the limitations of XI.rkennedy wrote:How many hosts / services do you have running in XI? This could just be growing as you add additional services with time.
- We receive the Service Alerts via email.lmiltchev wrote:Where do you see this? In the logs? Is this a check that you are running? Can you show us the config?
I would guess that you are still using the "default" setting of 100 max connections in the postgresql.conf:You could bump up this value a bit, and restart postgres so that changes can take effect.Code: Select all
max_connections = 100Code: Select all
service postgresql restart
I would adjust your warning / critical value accordingly and also raise the max_connections to say, 200. You shouldn't see any issues with doing this.TBT wrote:- We receive the Service Alerts via email.lmiltchev wrote:Where do you see this? In the logs? Is this a check that you are running? Can you show us the config?
I would guess that you are still using the "default" setting of 100 max connections in the postgresql.conf:You could bump up this value a bit, and restart postgres so that changes can take effect.Code: Select all
max_connections = 100Code: Select all
service postgresql restart
- We put these DB checks in place, with a 75% warning and 90% critical alarm.
- The /var/lib/pgsql/data/postgresql.conf has not been modified and currently contains "max_connections = 100"
Code: Select all
[root@localhost ~]# mysql -uroot -pnagiosxi -e "SHOW PROCESSLIST;" | wc -l
78