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