Re: Help Required

Hi,
Could you please elaborate as in how do we alter the fork limit of
cygwin and what exactly will happen after we have increased the value. The
number of connections specified in our postgresql.conf is 240 and shared
buffers as 480, by making it ~60 what will we be achieving ? Looking forward
to your reply.

regards
Kamalraj

----- Original Message -----
From: "Jason Tishler" <jason(at)tishler(dot)net>
To: "Kamalraj Singh Madhan" <kamalr(at)networkprograms(dot)com>
Cc: <pgsql-cygwin(at)postgresql(dot)org>
Sent: Wednesday, August 13, 2003 4:43 PM
Subject: Re: [CYGWIN] Help Required

> Kamalraj,
>
> On Wed, Aug 13, 2003 at 12:28:04PM +0530, Kamalraj Singh Madhan wrote:
> > I'am using PostGre SQL along with JBOSS and Tomcat for our
> > application. After quite some time of the usage of the application i
> > start getting these messages in my database console (Cygwin) :
> >
> >
> > DEBUG: geqo_main: using edge recombination crossover [ERX]
> > CheckPoint Data Base: fork failed: Resource temporarily unavailable
> > /usr/bin/postmaster: BackendStartup: fork failed: Resource temporarily
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> > unavailable - Backend startup failed
> > DEBUG: geqo_main: using edge recombination crossover [ERX]
> > CheckPoint Data Base: fork failed: Resource temporarily unavailable
> > CheckPoint Data Base: fork failed: Resource temporarily unavailable
> > DEBUG: geqo_main: using edge recombination crossover [ERX]
>
> My WAG is that you hit the Cygwin fork() limit of 63 children per
> parent. If I'm correct, then I recommend limiting your connections to
> ~60 if possible.
>
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html