Postgres Pro
Downloads
Home   >   mailing lists

Re: How to check if any WAL file is missing in archive folder - Mailing list pgsql-general

From Albe Laurenz
Subject Re: How to check if any WAL file is missing in archive folder
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C1B30B@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to How to check if any WAL file is missing in archive folder  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Responses Re: How to check if any WAL file is missing in archive folder  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Levenshtein Distance with more than 255 characters
Next
From: Szymon Guz
Date:
Subject: Re: Levenshtein Distance with more than 255 characters