Re: [HACKERS] Recovery Features

2004-07-10 Thread Jan Wieck
On 7/5/2004 6:16 PM, Simon Riggs wrote: On Mon, 2004-07-05 at 22:30, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: ...While recovering, it is very straightforward to simply ignore every record associated with one (or more) transactions. That gives us the ability to recover all apart

Re: [HACKERS] Recovery Features

2004-07-10 Thread Simon Riggs
On Sat, 2004-07-10 at 15:04, Jan Wieck wrote: On 7/5/2004 6:16 PM, Simon Riggs wrote: On Mon, 2004-07-05 at 22:30, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: ...While recovering, it is very straightforward to simply ignore every record associated with one (or more)

Re: [HACKERS] Recovery Features

2004-07-10 Thread Jan Wieck
On 7/10/2004 3:21 PM, Simon Riggs wrote: On Sat, 2004-07-10 at 15:04, Jan Wieck wrote: ...Nobody is shouting YES, so its a dodo... No way! Sorry...I meant this idea is dead, just like the extinct Dodo bird.- I've been trying to be succinct, but that has led to information loss. I know, preserve

Re: [HACKERS] Recovery Features

2004-07-06 Thread Simon Riggs
On Tue, 2004-07-06 at 00:30, Mike Mascari wrote: Simon Riggs wrote: On Mon, 2004-07-05 at 23:40, Mike Mascari wrote: hmmm...not sure I know what you mean. It is very-very-close-to-impossible to edit the transaction logs manually, unless some form of special-format editor were

Re: [HACKERS] Recovery Features

2004-07-05 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: ...While recovering, it is very straightforward to simply ignore every record associated with one (or more) transactions. That gives us the ability to recover all apart from txnid X. Don't even *think* of going there. What will happen when transaction Y

Re: [HACKERS] Recovery Features

2004-07-05 Thread Simon Riggs
On Mon, 2004-07-05 at 22:30, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: ...While recovering, it is very straightforward to simply ignore every record associated with one (or more) transactions. That gives us the ability to recover all apart from txnid X. Don't even *think* of

Re: [HACKERS] Recovery Features

2004-07-05 Thread Simon Riggs
On Mon, 2004-07-05 at 23:40, Mike Mascari wrote: Simon Riggs wrote: ...Nobody is shouting YES, so its a dodo... The point at which the above process becomes too complex (or less than obvious) for hand-recovery is precisely when unforeseen consequences of nixing a single transaction

Re: [HACKERS] Recovery Features

2004-07-05 Thread Mike Mascari
Simon Riggs wrote: On Mon, 2004-07-05 at 23:40, Mike Mascari wrote: hmmm...not sure I know what you mean. It is very-very-close-to-impossible to edit the transaction logs manually, unless some form of special-format editor were written for the purpose. Is it clear that the PITR features are