Re: [QUESTIONS] Basic table repair info.

Started by Thomas G. Lockhartalmost 28 years ago1 messages
#1Thomas G. Lockhart
lockhart@alumni.caltech.edu

I'd like to know what are the table repair tools. I examined a table with
od -c
and boy, that does not look like what I put in. So other than good old
fashioned backups, how do you rebuild a corrupted file ?
Just wonderin'

We don't need no sinking repair tools. :-)
Actually, we very rarely hear about any corruption problems, so there
are no repair tools.

Well, I've been wondering the same thing. I guess no one has been caught badly
enough to write the tools. It seems like one project could be to write a "recover
mode" into the backend, which would allow pg_dump to run to completion even though
a table is damaged. Would need a command line switch (or an SQL command) and then
some checks in the backend to return gracefully rather than throw an error and
quit.

- Tom