Re: Data Recovery

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.

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).

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

Thanks,

Alex Turner
netEconomist

On Wed, 16 Mar 2005 12:51:21 -0800, Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <armtuk(at)gmail(dot)com> wrote:
> > It's postgresl 8.01 on AMD 64 Suse 9.2. The database didn't dump
> > succesfully for several days in a row so the backup is corrupted also.
> >
> > The controller card crashed and we think caused data corruption. I
> > rebooted the system the following day, and it came back up, but all
> > was not well, pg_dump all failed that day, and the following day.
>
> Failed how? What options are you using and what kind of output are
> you seeing?
>
> What makes you think you had data corruption? What kind of filesystem
> are you using?
>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> L. Friedman netllama(at)gmail(dot)com
> LlamaLand http://netllama.linux-sxs.org
>