|
Hi all, I am Haiming, a software engineer. One of our product is depending on PostgreSQL. I am facing a problem that it somehow always gave me an error " server process (PID 1304) was terminated by exception 0xC0000142." or " No buffer space available (maximum connections reached?):
connect". I searched around and tried different configuration, but I still have not gotten any luck.
Any help would be appreciated. Setup: 1. Postgresql 9.1 2. Product language: Java 3. JDBC Pool:
BoneCP Here is my config: idleConnectionTestPeriod = 60 idleMaxAge = 240 maxConnectionsPerPartition = 35 minConnectionsPerPartition = 10 partitionCount = 5 and in postgresql.conf: max_connections = 600 shared_buffers = 32MB others are as default. This configuration is deployed in Windows XP with 4G Ram. I also tried Windows 7 and Windows Server 2008, the same issue occured. For Server 2008, my config is: idleConnectionTestPeriod = 60 idleMaxAge = 240 maxConnectionsPerPartition = 100 minConnectionsPerPartition = 5 partitionCount = 5 and in postgresql.conf: max_connections = 2000 shared_buffers = 2G others are as default. Many thanks Haiming Zhang Software Engineer If you are not an authorised recipient of this e-mail, please contact me at Redflex immediately by return phone call or by email. In this case, you should not read, print, retransmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. This e-mail and any attachments are confidential and may contain privileged information and/or copyright material of Redflex or third parties. You should only retransmit, distribute or commercialise the material if you are authorised to do so. This notice should not be removed. |
