On Sun, Oct 7, 2012 at 9:27 PM, gelin yan <dynamicgl@xxxxxxxxx> wrote: > > > On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang <Haiming.Zhang@xxxxxxxxxxxxxx> > 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. If the OP needs > 100 connections on the app end, he should add a connection pooler like pgbouncer or pgpool. pgbouncer is the easier of the two to configure. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
