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