Re: XLog changes for 9.3 - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: XLog changes for 9.3
Date
Msg-id 4FD0A1340200002500048191@gw.wicourts.gov
Whole thread Raw
In response to Re: XLog changes for 9.3  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: XLog changes for 9.3
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> But if you're just using regexp matching against pathnames, your
> tool will be just fine.  Do your tools actually rely on the
> occasional absence of a file in what would otherwise be the usual
> sequence of files?
To save "snapshot" backups for the long term, we generate a list of
the specific WAL files needed to reach a consistent recovery point
from a given base backup.  We keep monthly snapshot backups for a
year.  We currently determine the first and last file needed, and
then create a list of all the WAL files to save.  We error out if
any are missing, so we do skip the FF file.
-Kevin


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Could we replace SysV semaphores with latches?
Next
From: Robert Haas
Date:
Subject: Re: Early hint bit setting