Postgresql spawning a ridiculous number of postmaster processes

Posted by Kevin Loney on Server Fault See other posts from Server Fault or by Kevin Loney
Published on 2010-06-14T19:46:37Z Indexed on 2010/06/14 19:53 UTC
Read the original article Hit count: 340

Filed under:
|

For some reason postgres is spawning >700 postmaster processes for handling database requests and the postgres log file if full of 'unexpected EOF on client connection', 'incomplete startup packet' and 'sorry, too many clients already'. netstat tells me that all the open connections are local and I'm pretty sure are coming from postgres internally. This particular instance has been running just fine for the last 230 days or so and nothing has changed configuration wise. Any thoughts on where I should be looking to try and resolve this issue?

This is my first time diagnosing a problem like this so if there is any steps I can take to help narrow down the cause that would be helpful as well.

© Server Fault or respective owner

Related posts about postgresql

Related posts about postgresql-8.3