Thread: Too many processes

 Hi!

 Can anyone help me?

 I have a Linux/Apache/PHP/PostgreSQL server. It has about 35
 concurrent
 clients. The problem is it quickly (in a few hours) reaches 150 httpd
 and postmaster processes, making it stop responding. I tried both
 pg_connect() and pg_pconnect(), and I got similar results. The
 connection string is aways exactly the same. I don't think I should
 increase MaxClients beyond 150, because it doesn't have that many
 clients.

 Any help would be much appreciated.

 Cheers,

 Fabio




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Thanks for the answer Matthew. I just got it fixed. The problem was I
had maxconnections too high in postgresql.conf. I had increased it to
1000 because the default value of 100 was too low. It seemed that it
kept a lot of open connections even though I didn't use persistent
connections in PHP.

Well, the solution was decrease maxconnections to 200.

Cheers,

Fabio



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com