Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 904731337B5E for ; Fri, 10 Dec 2010 00:10:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 67966-09 for ; Fri, 10 Dec 2010 04:10:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from imail.internode.com.au (exchht01-ext.internode.com.au [203.26.95.185]) by mail.postgresql.org (Postfix) with ESMTP id E706213364DE for ; Fri, 10 Dec 2010 00:10:47 -0400 (AST) Received: from EXCHMAIL.staff.internode.com.au ([169.254.2.207]) by exchht01.staff.internode.com.au ([::1]) with mapi; Fri, 10 Dec 2010 14:40:45 +1030 From: Samuel Stearns To: Tom Lane CC: Shoaib Mir , "pgsql-admin@postgresql.org" Date: Fri, 10 Dec 2010 14:40:43 +1030 Subject: Re: Postgres Crash Thread-Topic: [ADMIN] Postgres Crash Thread-Index: AcuYHN/GRYgx8ETNQa2CzuEecbTN7AAA0rcQ Message-ID: <68B59BEDCD36854AADBDF17E91B2937A07844CD04D@EXCHMAIL.staff.internode.com.au> References: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au> <68B59BEDCD36854AADBDF17E91B2937A07844CD02E@EXCHMAIL.staff.internode.com.au> <13055.1291952802@sss.pgh.pa.us> In-Reply-To: <13055.1291952802@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=-0.788 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201012/67 X-Sequence-Number: 36296 Tom, Could it possibly be this?: http://postgresql.1045698.n5.nabble.com/BUG-5731-postmaster-sometimes-dumps= -core-when-handling-local-connections-td3239029.html Sam -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Friday, 10 December 2010 2:17 PM To: Samuel Stearns Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash=20 Samuel Stearns writes: > Tom, no useful messages in the log prior. I do have a 47M core dump. Wh= at should I do with that? If you use gdb, try $ gdb /path/to/postmaster /path/to/corefile gdb> bt ... useful info here ... gdb> quit I think the preferred debugger on Solaris might not be gdb, but if so you'll need to consult its docs to find out how to get a stack trace. regards, tom lane