BUG #2609: server crash at 182 connections still alive.

Confirmed here. I configured Postgresql to handle 200 connections and used a perl test script to open multiple connections to 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

Actually, it looks like the backend that handles the connection is the culprit and not the poastmaster. Sorry for the incorrect info.

----- Original Message ----
From: Shelby Cain <alyandon@yahoo.com>
To: Joek Hondius <jhondius@rem.nl>; pgsql-bugs@postgresql.org
Sent: Thursday, September 7, 2006 11:04:56 AM
Subject: Re: [BUGS] BUG #2609: server crash at 182 connections still alive.

Confirmed here. I configured Postgresql to handle 200 connections and used a perl test script to open multiple connections to 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