Re: Problem with PITR recovery

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