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.