The following bug has been logged online:

Bug reference: 2609
Logged by: Joek Hondius
Email address: jhondius (AT) rem (DOT) 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...5/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

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 (AT) rem (DOT) nl>
To: pgsql-bugs (AT) postgresql (DOT) 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 (AT) rem (DOT) 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...5/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




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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 (AT) yahoo (DOT) com>
To: Joek Hondius <jhondius (AT) rem (DOT) nl>; pgsql-bugs (AT) postgresql (DOT) 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





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings