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