PostgreSQL: Managing Kernel Resource for Cygwin

From: "James Yeung" <james_ck_yeung(at)yahoo(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: PostgreSQL: Managing Kernel Resource for Cygwin
Date: 2002-12-06 02:47:15
Message-ID: 000501c29cd1$cbc57ad0$6e01a8c0@jamesyeung
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Michael Weaver 2002-12-06 05:28:12 Running under Cygwin: stability - performance?
Previous Message Craig Addleman 2002-12-05 18:21:27 Re: postmaster7.3b5 service in Win2k cannot work properl