Re: PITR Archival - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: PITR Archival
Date
Msg-id 200406160053.i5G0r3R15056@candle.pha.pa.us
Whole thread Raw
In response to Re: PITR Archival  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Simon Riggs wrote:
> Also note: archive_mode is not designed to be turned on/off frequently.
> It is possible to confuse it if you turn it on, then restart with it
> off, then turn it on again. That is likely to create a "hole" in the
> archive history of xlogs and you will not be able to recover correctly.

I assume full xlog files will still be transfered, but that you will be
missing some files while the archiver was turned off.  That issue will
be part of the restore procedure, I assume.  I think we need to specify
people should use an empty archive directory every time they turn on
archiving.

--
  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, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Claudio Natoli
Date:
Subject: Re: stderr & win32 admin check
Next
From: Bruce Momjian
Date:
Subject: Re: PITR Archival