Re: PITR COPY Failure (was Point in Time Recovery) - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: PITR COPY Failure (was Point in Time Recovery)
Date
Msg-id 40FDD756.9030005@coretech.co.nz
Whole thread Raw
In response to Re: PITR COPY Failure (was Point in Time Recovery)  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
This is presumably a standard feature of any PITR design - if the 
failure event destroys the current transaction log, then you can only 
recover transactions that committed in the last *archived* log.

regards

Mark

Simon Riggs wrote:

>
>The test works, but gives what looks like strange results: the test
>blows away the data directory completely, so the then-current xlog dies
>too. That contained the commit for the large COPY, so even though the
>recovery now works, the table has zero rows in it. (When things die
>you're still likely to lose *some* data).
>
>
>
>  
>


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: PITR COPY Failure (was Point in Time Recovery)
Next
From: Gaetano Mendola
Date:
Subject: no instruction after install