Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6A1232E00F6 for ; Fri, 22 Feb 2008 12:58:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45412-03 for ; Fri, 22 Feb 2008 12:58:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BC2112E00E1 for ; Fri, 22 Feb 2008 12:58:22 -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 m1MGwKe6004922; Fri, 22 Feb 2008 11:58:20 -0500 (EST) To: Milen Evtimov cc: pgsql-admin@postgresql.org Subject: Re: server process (PID ) was terminated by signal 29 In-reply-to: <47BE803C.7@netinfo.bg> References: <47BE803C.7@netinfo.bg> Comments: In-reply-to Milen Evtimov message dated "Fri, 22 Feb 2008 09:56:44 +0200" Date: Fri, 22 Feb 2008 11:58:20 -0500 Message-ID: <4921.1203699500@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/278 X-Sequence-Number: 28352 Milen Evtimov writes: > After upgrading one of our database servers from 8.1.11 on SLES9 to > 8.2.6 on CentOS 5.1, it crashed several times with following errors: > LOG: server process (PID ) was terminated by signal 29 That's pretty odd. Would you confirm what signal 29 is on your machine? (On my Fedora 8 box, the numbers are defined in /usr/include/bits/signum.h --- it's probably the same on yours.) Fedora 8 says that 29 is SIGIO a/k/a SIGPOLL, but that doesn't make any sense to me --- we don't use any calls that would trigger that. Is this a locally built copy of Postgres, or an RPM installation? If the latter, which RPM exactly? regards, tom lane