Re: Disaster recovery: pg_class

From: Enrico <scotty(at)linuxtime(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disaster recovery: pg_class
Date: 2006-10-13 14:59:15
Message-ID: 20061013165915.36e0a788@mypc.ricordatasystem.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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(at)linuxtime(dot)it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brad Nicholson 2006-10-13 15:52:14 Re: postgres in HA constellation
Previous Message Tom Lane 2006-10-13 14:30:07 Re: Disaster recovery: pg_class