Re: hardware failure - data recovery

-----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?

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNxObS9HxQb37XmcRAkaJAKCKqIN76cHjvCqMJN3JqO7LBJZWfQCff2AT
WZWfEy3dWyByN2Q06IAt1kg=
=xmv+
-----END PGP SIGNATURE-----