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.
