Skip site navigation (1) Skip section navigation (2)

Re: is it cygwin or window2000 problem.?

From: "J(dot) Hondius" <jhondius(at)rem(dot)nl>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: is it cygwin or window2000 problem.?
Date: 2005-02-16 09:19:33
Message-ID: 000201c51408$a2781600$6755a8c0@JOEK (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin
Hi reini and yuzhouliu!

I get 62 connections with PostgreSQL 7.2 on cygwin + w2000.
Also stresstested it much like i described on
No crashing during high load.

The limitation is due to windows not having a fork() call (yet), which
cygwin tries to overcome with a ProcessCreate32() (whatever) call, but that
one is bound to a max of 64 with the same name by windows, and one (or 2)
are taken by the masterprocess. So you get 63/62.
62 is the safe side.

If you want more connections use the new native PostgreSQL 8.0.1 for windows
Or go to linux/bsd/unix for earlier versions. 
Dont forget to set the buffersize according to the description in

Greetings, J Hondius

-----Oorspronkelijk bericht-----
Van: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] Namens Reini Urban
Verzonden: woensdag 16 februari 2005 9:53
Aan: yuzhouliu
CC: pgsql-cygwin(at)postgresql(dot)org
Onderwerp: Re: [CYGWIN] is it cygwin or window2000 problem.?

yuzhouliu schrieb:
> Reini Urban wrote:
>> yuzhouliu schrieb:
>>> hello:
>>>     i install postgres in cygwin + windows2000NT,and it work good 
>>> for
>>> myself.
>>>     but more than 64 connections it will error to me:Could not fork 
>>> new process for connection:Resource temporarily unavailable.
>>>    why ? is it cygwin or window2000 problem.?
>> That's a builtin cygwin limitation.
>> But you are lucky that your system works with that many connections!
>> Recommended is to use much less. (5-15)
> you say :That's a builtin cygwin limitation,
> what and how can i i need to change my os to Linux or BSD,Unix?

you may not use max-connections > 63 on cygwin.
Recommended is 10. I can do up to 40.

initdb tries the correct values automatically on init.
If this is wrong, because your system is too fast, you may want to set 
this manually in /usr/share/postgresql/data/postgresql.conf and restart.
Reini Urban

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


In response to

pgsql-cygwin by date

Next:From: Sarah, Godfrey, Matthew & VeraDate: 2005-02-17 08:27:40
Subject: Cygwin configuration trouble
Previous:From: Reini UrbanDate: 2005-02-16 08:53:10
Subject: Re: is it cygwin or window2000 problem.?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group