On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang <haiming.zh...@redflex.com.au>wrote:
> 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
