Re: hardware failure - data recovery - Mailing list pgsql-general

From Rick Gigger
Subject Re: hardware failure - data recovery
Date
Msg-id 45376C36.4050107@alpinenetworking.com
Whole thread Raw
In response to Re: hardware failure - data recovery  (Rick Gigger <rick@alpinenetworking.com>)
List pgsql-general
Rick Gigger wrote:
> 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?

Oh.  Yeah.  Everything was backed up but this one thing. Hence the need
to get the data from the messed up db.

I think we've got it figure out though.  We were able to patch up the db
enough to extract the data with some help from google and old postings
from Tom.

Thanks,

Rick

pgsql-general by date:

Previous
From: "Peter Bauer"
Date:
Subject: Overload after some minutes, please help!
Next
From: Tomasz Ostrowski
Date:
Subject: Re: Overload after some minutes, please help!