For long running transactions where you want to recover as much as possible, one might also want to recover up until just before a specific transaction committed (as opposed to started).
If your DB has died and you are recovering it, how do you reestablish a session so that a transaction can complete ? Doesn't all client connections assume that a transaction has failed if the connection to the DB fails ?
Or am I just being naive, as usual ?
Peter
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
