On Sat, 2008-01-19 at 11:51 -0500, Tom Lane wrote: > Simon Riggs <simon@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
