On Fri, Sep 6, 2013 at 4:04 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote: > ascot.moss@xxxxxxxxx wrote: >> I am planing to backup archived WAL files from master to another machine, is there a way to check and >> make sure the backup archive file are all good and no any file missing or corrupted? > > The only 100% safe way would be to restore them, e.g. with > a standby database. To check if any file is missing, you can check directly with the WAL file names. Note that the format name of WAL files has changed a bit in 9.3 as they can end with FF. In 9.2 and prior versions, it finished at most with FE. This won't ensure that the content is safe though, so use one of the methods mentioned previously in this thread. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
