Thread: PostgreSQL: Managing Kernel Resource for Cygwin

PostgreSQL: Managing Kernel Resource for Cygwin

From

"James Yeung"

Date:

11 December 2002, 12:03:18

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

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

Re: PostgreSQL: Managing Kernel Resource for Cygwin

From

"Henshall, Stuart - Design & Print"

Date:

11 December 2002, 15:02:48

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@yahoo.com]
Sent: 06 December 2002 02:47
To: pgsql-cygwin@postgresql.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