Re: Data Recovery - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: Data Recovery
Date
Msg-id 7c1574a9050316130511a1d54a@mail.gmail.com
Whole thread Raw
In response to Re: Data Recovery  (Alex Turner <armtuk@gmail.com>)
List pgsql-general
On Wed, 16 Mar 2005 16:02:58 -0500, Alex Turner <armtuk@gmail.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@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: Data Recovery
Next
From: Lonni J Friedman
Date:
Subject: Re: Data Recovery