Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <41443B93.4020000@x-ray.at>
Date: Sun, 12 Sep 2004 14:05:39 +0200
From: Reini Urban <rurban AT x-ray DOT at>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a2) Gecko/20040714
MIME-Version: 1.0
To: cygwin <cygwin AT cygwin DOT com>
Subject: cygserver problem max 5 connections
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

I have a postgres user claiming that cygserver cannot serve more than 5 
concurrent connections with postgres.

In my own tests it showed that postmaster really crashed at the parallel 
regression test suite.
ipcs showed five semaphores and one shm area.
The serial tests work fine with up to 40-100 max_connections.
And the initdb process, which automatically chooses max_connections by 
trying it out until it works, usually gives 50-100 max_connections.
any comments?

how to debug such concurrency problems?
I have a debug build of cygserver, which obviously cannot serve that 
many concurrent connections, but doesn't crash either.

====
There is currently no production release of PostgreSQL that runs more 
than 5 concurrent sessions in Windows because the releases available for 
Cygwin, 7.4.3 to 7.4.5 are built with Cygserver which has a bug that 
have PostgreSQL hung with more than 5 concurrent connections.

I am planning to revert to PostgreSQL 7.1 which is the latest cygwin 
package built with cygipc (instead of cygserver).

It would be nice to have the latest releases of PostgreSQL rebuilt with 
cygipc and available
as cygwin packages.

Thanks
Jean-Pierre Pelletier
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/