Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 431FB1337B94 for ; Fri, 10 Dec 2010 00:57:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80586-07 for ; Fri, 10 Dec 2010 04:57:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from imail.internode.com.au (exchht02-ext.internode.com.au [203.26.95.186]) by mail.postgresql.org (Postfix) with ESMTP id 84A1D1337B5E for ; Fri, 10 Dec 2010 00:57:19 -0400 (AST) Received: from EXCHMAIL.staff.internode.com.au ([169.254.2.207]) by exchht02.staff.internode.com.au ([::1]) with mapi; Fri, 10 Dec 2010 15:27:16 +1030 From: Samuel Stearns To: Tom Lane CC: Shoaib Mir , "pgsql-admin@postgresql.org" Date: Fri, 10 Dec 2010 15:27:14 +1030 Subject: Re: Postgres Crash Thread-Topic: [ADMIN] Postgres Crash Thread-Index: AcuYJg1WxzAGeeVDR3+jTZ1txdKZdAAAHIOg Message-ID: <68B59BEDCD36854AADBDF17E91B2937A07844CD06C@EXCHMAIL.staff.internode.com.au> References: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au> <68B59BEDCD36854AADBDF17E91B2937A07844CD02E@EXCHMAIL.staff.internode.com.au> <13055.1291952802@sss.pgh.pa.us> <68B59BEDCD36854AADBDF17E91B2937A07844CD04D@EXCHMAIL.staff.internode.com.au> <13945.1291954973@sss.pgh.pa.us> <68B59BEDCD36854AADBDF17E91B2937A07844CD059@EXCHMAIL.staff.internode.com.au> <14104.1291955542@sss.pgh.pa.us> <68B59BEDCD36854AADBDF17E91B2937A07844CD061@EXCHMAIL.staff.internode.com.au> <14434.1291956744@sss.pgh.pa.us> In-Reply-To: <14434.1291956744@sss.pgh.pa.us> Accept-Language: en-US, en-AU Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US, en-AU Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_FRT_STOCK2=0.01, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/74 X-Sequence-Number: 36303 Tom, So you are in agreement that the fix is: This simple patch seem to fix the problem --- src/backend/postmaster/postmaster.c.orig 2010-10-27 19:07:42.000000000 +0400 +++ src/backend/postmaster/postmaster.c 2010-10-27 19:08:25.000000000 +0400 @@ -1917,7 +1917,7 @@ if (port->sock >=3D 0) StreamClose(port->sock); ConnFree(port); - port =3D NULL; + return NULL; } else { --