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.
Hi
Could you try reducing your max_connection to 100 or some smaller numbers? also you may try 64 bit version if yours isn't.
Regards
gelin yan
