Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B8E1162EA40 for ; Wed, 27 Jan 2010 19:59:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 08974-01 for ; Wed, 27 Jan 2010 23:59:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 50CFB633969 for ; Wed, 27 Jan 2010 19:59:14 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o0RNxAuK017032; Wed, 27 Jan 2010 18:59:10 -0500 (EST) To: pg2@onet.eu cc: pgsql-bugs@postgresql.org Subject: Re: problem with segmentation fault error In-reply-to: References: Comments: In-reply-to pg2@onet.eu message dated "Wed, 27 Jan 2010 22:27:01 +0100" Date: Wed, 27 Jan 2010 18:59:10 -0500 Message-ID: <17031.1264636750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.463 tagged_above=-10 required=5 tests=AWL=0.136, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201001/244 X-Sequence-Number: 25748 pg2@onet.eu writes: > 2010-01-27 10:34:01 CET [3931]: [9-1] host=,user=,db= LOG: server process (PID 24454) was terminated by signal 11: Segmentation fault > I have 8.4.0 version. The *first* thing to do is update to 8.4.2 to see if the problem was already fixed. If not, you need to try to gather some data. What query was running in the crashed backend would be useful to know, and a stack trace would be even better. > Do you have any idea where problem could be? Is it hardware or rather PostgreSQL configuration problem? It could be a hardware problem or a software bug. How reproducible is it? regards, tom lane