Confirmed here. I configured Postgresql to handle 200 connections and used a perl test script to open multiple
connectionsto the database. The postmaster crashes consistently when the 182nd connection is opened.
select version();
"PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)"
Regards,
Shelby Cain
----- Original Message ----
From: Joek Hondius <jhondius@rem.nl>
To: pgsql-bugs@postgresql.org
Sent: Thursday, September 7, 2006 7:47:24 AM
Subject: [BUGS] BUG #2609: server crash at 182 connections still alive.
The following bug has been logged online:
Bug reference: 2609
Logged by: Joek Hondius
Email address: jhondius@rem.nl
PostgreSQL version: 8.1
Operating system: Windows
Description: server crash at 182 connections still alive.
Details:
See BUG #1641: Server crash at 182 connections
http://archives.postgresql.org/pgsql-bugs/2005-05/msg00006.php
The exact same bug still exists in version 8.1
This affects the professional deployment of PostgreSQL for windows as a
enterprise solution.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
