Problem with PITR recovery

From: Bruce Momjian
Subject: Problem with PITR recovery
Date: ,
Msg-id: 200504160511.j3G5B6x29421@candle.pha.pa.us
(view: Whole thread, Raw)
Responses: Re: Problem with PITR recovery  (Tom Lane)
List: pgsql-hackers

Tree view

Problem with PITR recovery  (Bruce Momjian, )
 Re: Problem with PITR recovery  (Tom Lane, )
  Re: Problem with PITR recovery  (Bruce Momjian, )
   Re: Problem with PITR recovery  (Ragnar Hafstað, )
    Re: Problem with PITR recovery  (Bruce Momjian, )
     Re: Problem with PITR recovery  (Tom Lane, )
      Re: Problem with PITR recovery  (Bruce Momjian, )
       Re: Problem with PITR recovery  (Tom Lane, )
        Re: Problem with PITR recovery  (Bruce Momjian, )
         Re: Problem with PITR recovery  (Simon Riggs, )
          Re: Problem with PITR recovery  (Bruce Momjian, )
          Re: Problem with PITR recovery  (Oleg Bartunov, )
           Re: Problem with PITR recovery  (Simon Riggs, )
            Re: Problem with PITR recovery  (Oleg Bartunov, )
             Re: Problem with PITR recovery  (Jeff Davis, )
              Re: Problem with PITR recovery  (Bruce Momjian, )
              Re: Problem with PITR recovery  (Oleg Bartunov, )
   Re: Problem with PITR recovery  (Bruce Momjian, )
    Re: Problem with PITR recovery  (Jeff Davis, )
     Re: Problem with PITR recovery  (Bruce Momjian, )
      Re: Problem with PITR recovery  (Jeff Davis, )
       Re: Problem with PITR recovery  (Bruce Momjian, )
        Re: Problem with PITR recovery  (Greg Stark, )
         Re: Problem with PITR recovery  (Bruce Momjian, )
          Re: Problem with PITR recovery  (Greg Stark, )
      Re: Problem with PITR recovery  (Oleg Bartunov, )
       Re: Problem with PITR recovery  (Bruce Momjian, )
 Re: Problem with PITR recovery  (Bruce Momjian, )
 Re: Problem with PITR recovery  (Rob Butler, )
  Re: Problem with PITR recovery  (Oleg Bartunov, )
   Re: Problem with PITR recovery  (Bruce Momjian, )
  Re: Problem with PITR recovery  (Bruce Momjian, )
   Re: Problem with PITR recovery  (Tom Lane, )
    Re: Problem with PITR recovery  (Bruce Momjian, )
     Re: Problem with PITR recovery  (Tom Lane, )
      Re: Problem with PITR recovery  (Bruce Momjian, )

I had a problem using PITR recovery just now.  If I do:
SELECT pg_start_backup('label');do my tarSELECT pg_stop_backup();

and stop the server, delete /data, then recover from the tar, delete
files in pg_xlog, then set recovery.conf to restore, it fails, I think
because no actual pg_xlog file was archived since the tar.

The problem is that we don't archive the partially written xlog file,
and in this case that xlog file contains the information needed to make
the tar file consistent.

Is this a known problem?  Do we document this?  If so, I can't find it. 

I am concerned about folks cleaning out their archive directory after
the pg_stop_backup() not realizing they need that last xlog file to make
the tar valid.

--  Bruce Momjian                        |  http://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:

From: Bruce Momjian
Date:
Subject: Problem with PITR recovery
From: Tom Lane
Date:
Subject: Re: Problem with PITR recovery