Simon Riggs <[EMAIL PROTECTED]> writes: > Currently, recovery loops until end of xlogs. There is no exit condition > from the loop. There is not currently a timestamp on the xlogs - > anywhere apart from the file date on each xlog.
Sure there is: every transaction commit record (and I think abort as well) carries a timestamp. This was put in with PITR in mind in the very beginning. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])