| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Robert Haas" <robertmhaas(at)gmail(dot)com> |
| Cc: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: XLog changes for 9.3 |
| Date: | 2012-06-07 17:40:20 |
| Message-ID: | 4FD0A1340200002500048191@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-06-07 17:40:49 | Re: Early hint bit setting |
| Previous Message | Stefan Kaltenbrunner | 2012-06-07 17:27:48 | Re: Could we replace SysV semaphores with latches? |