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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
