I am using postgresql, and apache. The pconnects are not being closed, or reused to some extent.
I recieve the message:
Warning: Unable to connect to PostgreSQL server: Sorry, too many clients already
While that is true, and something that can be increased with postgres, there are few, if any people on the web server. There are plenty of open "inactive" connections which should be reused. I can fix the problem by restarting apache.
Is there something I am missing? The whole point of pconnect is to reuse connections, right? Is there a way to either set a timeout, or "force" reuse of connections?
Thanks,
-Pete
I recieve the message:
Warning: Unable to connect to PostgreSQL server: Sorry, too many clients already
While that is true, and something that can be increased with postgres, there are few, if any people on the web server. There are plenty of open "inactive" connections which should be reused. I can fix the problem by restarting apache.
Is there something I am missing? The whole point of pconnect is to reuse connections, right? Is there a way to either set a timeout, or "force" reuse of connections?
Thanks,
-Pete