X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 025509DCC63 for ; Wed, 21 Dec 2005 21:13:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60708-03 for ; Wed, 21 Dec 2005 21:13:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by postgresql.org (Postfix) with ESMTP id 762A19DC84B for ; Wed, 21 Dec 2005 21:13:10 -0400 (AST) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id 002FC2396BD; Wed, 21 Dec 2005 20:13:13 -0500 (EST) Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id 67882-01-8; Wed, 21 Dec 2005 20:13:12 -0500 (EST) Received: from [192.168.0.101] (CPE3285f62f0d42-CM0011aec5ebbc.cpe.net.cable.rogers.com [69.197.146.229]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id B6FB6239674; Wed, 21 Dec 2005 20:13:12 -0500 (EST) Message-ID: <43A9FDC4.40901@samurai.com> Date: Wed, 21 Dec 2005 20:13:40 -0500 From: Neil Conway User-Agent: Thunderbird 1.5 (Macintosh/20051201) MIME-Version: 1.0 To: barai@cs.ucr.edu CC: pgsql-general@postgresql.org Subject: Re: PostgreSQL crashing References: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu> In-Reply-To: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/1041 X-Sequence-Number: 88604 barai@cs.ucr.edu wrote: > PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes. > Dec 20 17:14:57 server4 kernel: postmaster: page allocation failure. > order:0, mode:0xd0 > Dec 20 17:14:57 server4 kernel: [] __alloc_pages+0x2e1/0x2f7 This looks like a kernel or hardware issue, not a problem with PostgreSQL itself. -Neil