SUMMARY
Database is not responding and needs to be restarted. The pg_log contains the message "FATAL: sorry, too many clients already"
ISSUE
- Database is not responding or is not accessible via psql
- Need to restart the database
- The pg_log displays "FATAL: sorry, too many clients already"
RESOLUTION
Stop and then restart the database:
/etc/init.d/bp_rcscript stop /etc/init.d/bp_rcscript start
CAUSE
The database has too many client connections. The database can only handle 400 connections at one time. The number of postgres database connections can be view with the following command:
ps ax | grep post | wc -l