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

Re: All Production releases of PostgreSQL hung because of

From: "J(dot) Hondius" <jhondius(at)rem(dot)nl>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: All Production releases of PostgreSQL hung because of
Date: 2004-09-13 08:28:39
Message-ID: 000b01c4996b$af713980$18884fc1@JOEK (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi.

I have postgreSQL version 7.2.1 /w cygwin running fine with more than 5
concurrent connections.
Normal 7.2.1 distro. Tested up to 12.

BTW: postgresql-cygwin cannot handle more than 62 concurrent client
connections due to a limitation in windows, 
no matter what postgresql.conf says.

Greetings, Joek




-----Oorspronkelijk bericht-----
Van: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] Namens Reini Urban
Verzonden: zaterdag 11 september 2004 11:43
Aan: cygwin
CC: pgsql-cygwin(at)postgresql(dot)org
Onderwerp: Re: [CYGWIN] All Production releases of PostgreSQL hung because
of


Jean-Pierre Pelletier schrieb:
> 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.

Hmm, that would explain the crash at the parallel_schedule regression 
suite. ipcs showed 5 semaphores, and one shm, when postmaster crashed.
serial tests do work fine. max_connections=100 also works fine.

Do you have any link where this is discussed/analyzed?

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

No problem.
If it's really a buggy cygserver I'll do a interim cygipc version. I already
had one, but it clashed with cygserver.

But I really want to try to debug cygserver then.

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match


In response to

Responses

pgsql-cygwin by date

Next:From: Nah CPDate: 2004-09-13 08:35:22
Subject: Insert data to new table
Previous:From: tracy ongDate: 2004-09-13 05:11:38
Subject: FATAL: lock file "usr/local/pgsql/data/postmaster.pid already exist

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