Re: WARNINGs after starting backup server created with PITR

On Sat, 2008-01-19 at 11:51 -0500, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)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