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
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 |