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: 335
postgresql
|postgresql-8.3
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