Thread: 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.
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
Actually, it looks like the backend that handles the connection is the culprit and not the poastmaster. Sorry for the incorrectinfo. ----- 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 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