Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 638009FA4CF for ; Fri, 13 Oct 2006 11:55:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96217-03 for ; Fri, 13 Oct 2006 11:54:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from dns.ricordatasystem.int (host10-241-static.73-81-b.business.telecomitalia.it [81.73.241.10]) by postgresql.org (Postfix) with SMTP id 8014E9F9EF3 for ; Fri, 13 Oct 2006 11:54:47 -0300 (ADT) Received: (qmail 24079 invoked by uid 1013); 13 Oct 2006 15:34:03 -0000 Received: from unknown (HELO mypc.ricordatasystem.info) (192.168.2.50) by dns.ricordatasystem.int with SMTP; 13 Oct 2006 15:34:03 -0000 Date: Fri, 13 Oct 2006 16:59:15 +0200 From: Enrico To: pgsql-admin@postgresql.org Subject: Re: Disaster recovery: pg_class Message-ID: <20061013165915.36e0a788@mypc.ricordatasystem.info> In-Reply-To: <29602.1160749807@sss.pgh.pa.us> References: <20061013112929.1cbb7b9e@mypc.ricordatasystem.info> <29602.1160749807@sss.pgh.pa.us> X-Mailer: Sylpheed-Claws 1.0.4 (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/92 X-Sequence-Number: 23395 > I'm not convinced there's anything much there you need to fix. You > should look into why the filesystem seems to have lost part of your WAL > file --- that strongly suggests that the disk or kernel is lying about > write ordering, which will cause you problems eventually. But this > message per se will go away as soon as the WAL endpoint moves another > 1.5Mb. Unless there's other corruption elsewhere you'll be fine. > > regards, tom lane Hi Tom, I think that the system crash is due to a ram failure, my server doesn't start if is present a specific bank of ram, and without it, it works fine. I watched logs and in the /var/mail/postgres and I've seen this error that matchs in time with system crash. pg_dump: ERROR: invalid memory alloc request size 18446744073709551613 regards Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!! scotty@linuxtime.it - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi