On Sat, 2008-01-19 at 11:51 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > The page numbers are identical between both systems, so use the
> > contrib/pageinspect get_raw_page() function to record the contents on
> > both systems before they diverge too much. (BTW, the final commit of
> > those tools seems to have removed the docs I wrote for the original
> > version and haven't been replaced with a README -- huh!?).
>
> You mean
> http://developer.postgresql.org/pgdocs/postgres/pageinspect.html
> ?
Many thanks, I didn't realise we had done that.
> But in any case that module doesn't exist in 8.2 or before, so
> Erik would probably have a hard time using it.
If we can diagnose a bug by doing this, surely that is the right thing
to do? I think the versions wouldn't be that different anyway.
If we can find a row that is missing in the standby version then we will
have at least found a bullet hole.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com