Ask the Community
Groups
FATAL: Sorry, too many clients already. - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Database is not responding and needs to be restarted. The pg_log contains the message "FATAL: sorry, too many clients already"</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <ul><li>Database is not responding or is not accessible via psql</li> <li>Need to restart the database</li> <li>The pg_log displays "FATAL: sorry, too many clients already"</li> </ul><h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>Stop and then restart the database:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0"> /etc/init.d/bp_rcscript stop /etc/init.d/bp_rcscript start</pre> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p></p> <p>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:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0"> ps ax | grep post | wc -l</pre> </article> </main>