On Sat, 2008-01-19 at 13:53 -0600, Erik Jones wrote:
> > Is the History table Insert only? We might use that fact to examine
> > the
> > LSNs of the equivalent blocks on the Primary. If the LSNs are prior to
> > the start of the recovery, as noted in the backup label file of the
> > original base backup, then we can confirm rsync or postgres as the
> > cause. Do you still have the base backup label file or base backup?
>
> I still have the backup label but not the base backup. The history
> tables are about 90-95% insert only, on average, but they do see the
> occasional update if a message's delivery status is a bounce. If you
> think this would still be an option, I'd be happy to follow whatever
> instructions, or supply any files, needed.
OK. Off-list, please post me the backup label file and 2-3 compressed
WAL files covering the period where recovery started.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com