Re: Data Recovery

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: Alex Turner <armtuk(at)gmail(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data Recovery
Date: 2005-03-16 21:05:37
Message-ID: 7c1574a9050316130511a1d54a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 16 Mar 2005 16:02:58 -0500, Alex Turner <armtuk(at)gmail(dot)com> wrote:
> Fsync was off - we are using XFS and the Microcontroller on the RAID
> card Crashed and took two filesystems offline at about 2 a.m.

Did you run xfs_repair afterwards?

> There were some error messages in the postgres log, something like
> Update failed - right part of branch is wrong (I'm guessing - I'm
> trying to find the exact error - but we do 10 hits/second and there
> are alot of logs).

Knowing/seeing those errors would be useful.

>
> The pg_dumpall would get to a certain table and crap out - it would
> just not read anymore data.

crap out meaning what exactly? Is it hanging? Is there an error message?

Seriously, you need to provide information here. Too much is better
than the trickle that you've provided thus far.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-03-16 21:10:59 Re: Data Recovery
Previous Message Alex Turner 2005-03-16 21:05:16 Re: Data Recovery