ascot.moss@gmail.com 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.
PostgreSQL 9.3 will also have "xlogdump" which you can run on the WAL file.
If that does not gag, the file is probably ok.
Yours,
Laurenz Albe