Tom Lane wrote:
> Neil Conway <neilc@samurai.com> writes:
> > Having better tools is hardly a bad thing, and I don't think having
> > better tools would require making an "admission" about the reliability
> > of our software. I was just saying that there's room for improvement:
> > for instance, tools like pg_filedump and pgfsck could be a lot more
> > polished and feature-complete, and the whole process of recovering from
> > data corruption could be better documented.
>
> The point I was trying to make is that recovery is never a cookbook
> process --- it's never twice the same problem.
Well, TOAST pointer problems are very frequent, even though they are
typically hardware-related. An heuristic-based tool to try to guess
values for invalid tuples is not impossible, I'd guess.
I've never even tried written such a thing though.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support