Re: hardware failure - data recovery

Ron Johnson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 10/19/06 00:46, Rick Gigger wrote:
>> Ron Johnson wrote:
>>> On 10/18/06 23:52, Rick Gigger wrote:
>>>> Rick Gigger wrote:
>>>>> Ron Johnson wrote:
>>>>>> On 10/18/06 19:57, Rick Gigger wrote:
> [snip]
>> Not much that is useful.  I think this is a little beyond that scope.  A
>> hardware failure basically left the fs and the db in an inconsistent
>> state.  There is one table in one database that has a bunch of data in
>> it that I need to get out.  I'm guessing I'm going to need to find
>> someone who understands the the internal structure of the files to go in
>> and pull out whatever data is still in tact.
>
> So, no backup tapes?
>
>> I have been poking around and as far as I can tell, although one of the
>> toast indexes is gone the actual table files appear to be in tact.  That
>> is they are still in the file system.  I don't know if they are ok
>> internally.
>>
>> I also get this error when trying to access the non-toasted data:
>>
>> ERROR:  could not access status of transaction 307904873
>> DETAIL:  could not open file "pg_clog/0125": No such file or directory
>>
>> I'm guessing that this means that I may have get someone to pull out all
>> versions of a given tuple because I have lost some of the visibility
>> info.  This shouldn't matter as most likely very few tuples would have
>> had more than one version when the system went down.
>>
>> I just hope that the relations are need are in tact and that there is
>> someone out there who can help me get it out.
>
> What kernel, version & fs?

Linux. 2.4.22. and ext3.