Re: BUG #3484: Missing pg_clog file / corrupt index - Mailing list pgsql-bugs

From Marc Schablewski
Subject Re: BUG #3484: Missing pg_clog file / corrupt index
Date
Msg-id 46AF0D38.8020504@clickware.de
Whole thread Raw
In response to Re: BUG #3484: Missing pg_clog file / corrupt index  (Decibel! <decibel@decibel.org>)
Responses Re: BUG #3484: Missing pg_clog file / corrupt index  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-bugs
I kept a copy of the data files in case it is needed, but I have to
check first, if I am allowed to give away that information. Some of the
data is confidential. If you just need the files containing the dammaged
table, this won't be a big problem, because it does not contain any
confidential information (as long as one data file only contains the
data of one table). The other problem is the size of the files. The
whole database is about 60GB and the files belonging to that table are
about 2.5GB. Mayby there is a way to pre-select the data you need?


Decibel! wrote:
> Actually, this does sound like a hardware problem to me. You only have 5
> tables that get hit heavily, so you've likely got somewhere around a 20%
> chance that corruption would hit the same table on two different machines.
>
> So far you haven't said anything that sounds unusual about how you're
> using the database, and the hardware certainly seems pretty
> common-place, so I'm rather doubtful that it's software. But if you
> still have copies of the bad database, someone might be able to help you.

--

Marc Schablewski
click:ware Informationstechnik GmbH

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3494: may be Query Error: subplan does not executed
Next
From: Gregory Stark
Date:
Subject: Re: BUG #3484: Missing pg_clog file / corrupt index