On Thu, 14 Jun 2007, Frank Wittig wrote:
But I also agree that if there is a possibility that times differ (and there of course is) the question is not if it can happen but when.
Sure, but it doesn't matter one bit if the times between the primary and secondary servers differ. If the timestamps on the primary are being preserved when copied over, the secondary can operate on them with no reference whatsoever to its local time. Future transaction timestamps will be all screwed up when you switch to the secondary if its clock is wrong, but it doesn't impact the operation of the PITR mechanism or its cleanup.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
