Robert Haas <robertmh...@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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to