Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 642BB19F3CE for ; Mon, 11 Jun 2012 16:16:05 -0300 (ADT) Received: from ec2-23-23-181-247.compute-1.amazonaws.com ([23.23.181.247] helo=nebula.troocorp.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SeA5p-00011O-D7 for pgsql-general@postgresql.org; Mon, 11 Jun 2012 19:16:05 +0000 Received: from localhost (localhost [127.0.0.1]) by nebula.troocorp.com (Postfix) with ESMTP id 26FF2776002; Mon, 11 Jun 2012 19:15:26 +0000 (UTC) X-Virus-Scanned: amavisd-new at troocorp.com Received: from nebula.troocorp.com ([127.0.0.1]) by localhost (nebula.troocorp.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9JQu+o7it-Bd; Mon, 11 Jun 2012 19:15:20 +0000 (UTC) Received: from nebula.troocorp.com (nebula.troocorp.com [10.114.218.85]) by nebula.troocorp.com (Postfix) with ESMTP id 9758F776001; Mon, 11 Jun 2012 19:15:20 +0000 (UTC) Date: Mon, 11 Jun 2012 19:15:20 +0000 (UTC) From: Benson Jin To: Craig Ringer Cc: pgsql-general@postgresql.org Message-ID: <299885816.271173.1339442120437.JavaMail.root@troo.com> In-Reply-To: <4FD5A315.600@ringerc.id.au> Subject: Re: Segmentation Fault MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_271172_1248745021.1339442120436" X-Originating-IP: [99.245.249.129] X-Mailer: Zimbra 7.2.0_GA_2669 (ZimbraWebClient - GC19 (Win)/7.2.0_GA_2669) X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201206/230 X-Sequence-Number: 188010 ------=_Part_271172_1248745021.1339442120436 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi All, A silly question.... how do I get install external symbols for postgresql, if compiled it myself previously? Do I recompile it with --enable-debug option? Cheers, Benson ----- Original Message ----- From: "Craig Ringer" To: "Benson Jin" Cc: pgsql-general@postgresql.org Sent: Monday, June 11, 2012 3:49:41 AM Subject: Re: [GENERAL] Segmentation Fault On 06/11/2012 11:34 AM, Benson Jin wrote: Hi All, We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault". Any chance of examining a core dump and getting a stack trace? http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD -- Craig Ringer ------=_Part_271172_1248745021.1339442120436 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
Hi All,

A silly question.... how do I get install external symbols for postgresql, if compiled it myself previously? Do I recompile it with --enable-debug option?

Cheers,

Benson

From: "Craig Ringer" <ringerc@ringerc.id.au>
To: "Benson Jin" <benson.jin@troo.com>
Cc: pgsql-general@postgresql.org
Sent: Monday, June 11, 2012 3:49:41 AM
Subject: Re: [GENERAL] Segmentation Fault

On 06/11/2012 11:34 AM, Benson Jin wrote:
Hi All,

We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault".

Any chance of examining a core dump and getting a stack trace?

http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

--
Craig Ringer

------=_Part_271172_1248745021.1339442120436--