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