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 <[EMAIL PROTECTED]> wrote: > On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > LlamaLand http://netllama.linux-sxs.org > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
