Re: PostgreSQL: Managing Kernel Resource for Cygwin

You've hit a limit in cgywin. A process can only have 62 children (IIRC). :(
There has been previous mention of this on the archives (and on the cygwin
site)
Sorry to be the bearer of bad tidings :(
- Stuart

-----Original Message-----
From: James Yeung [mailto:james_ck_yeung(at)yahoo(dot)com]
Sent: 06 December 2002 02:47
To: pgsql-cygwin(at)postgresql(dot)org
Subject: [CYGWIN] PostgreSQL: Managing Kernel Resource for Cygwin

Hi,

Basically i need more than 100 concurrent database connections to the
PostgreSQL 7.2.3 setup on top of the Cygwin 1.3.1 running under the W2k box.
After configure the postgresql.conf to accept 320 connections with the
buffer set to 640 whilst starting the postmaster, it will hit Resource
temporarily unavailable when I had secure more than 59 connections. The
error messages from postmaster are as the follow:-

DEBUG: database system is ready

DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable

DEBUG: could not launch checkpoint process (fork failure): Resource
temporarily unavailable

DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable

DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable

DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable

One way to resolve the issue might be to set higher value in the maximum
number of processes per user, MAXUPRC and NFILE/NINODE - maximum number of
open file.

After gone through a number of FAQ, manuals and no solution found to reset
the MAXUPRC and the other limits under the Cygwin.

Am I heading a correct direction? Are there any other way to get around the
problem?

Thanks and regards,

James Yeung