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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
