FATAL: Sorry, too many clients already.

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us