Re: Problem with PITR recovery - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problem with PITR recovery
Date
Msg-id 200504180300.j3I30e010122@candle.pha.pa.us
Whole thread Raw
In response to Problem with PITR recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
pgman wrote:
> I figured that part of the goal of PITR was that you could recover from
> just the tar backup and archived WAL files --- using the pg_xlog
> contents is nice, but not something we can require.
> 
> I understood the last missing WAL log would cause missing information,
> but not that it would make the tar backup unusable.
> 
> It would be nice if we could force a new WAL file on pg_stop_backup()
> and archive the WAL file needed to match the tar file.  How hard would
> that be?

Added to TODO:

* Force archiving of partially-full WAL files when pg_stop_backup() is called or the server is stopped

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Ilya A. Kovalenko"
Date:
Subject: Re: inet increment w/ int8
Next
From: Jeff Davis
Date:
Subject: Re: Problem with PITR recovery