Re: WARNINGs after starting backup server created with PITR - Mailing list pgsql-general

From Simon Riggs
Subject Re: WARNINGs after starting backup server created with PITR
Date
Msg-id 1200762237.4255.436.camel@ebony.site
Whole thread Raw
In response to Re: WARNINGs after starting backup server created with PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: WARNINGs after starting backup server created with PITR
Next
From: "Sue Fitt"
Date:
Subject: Re: turning off notices