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

From Michael Paquier
Subject Re: How to check if any WAL file is missing in archive folder
Date
Msg-id CAB7nPqT4u6VmFX9HvEFMpHQMBUMSXW+dKzVtdPYTzaHqJQpm3Q@mail.gmail.com
Whole thread Raw
In response to Re: How to check if any WAL file is missing in archive folder  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
On Fri, Sep 6, 2013 at 4:04 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> 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.
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


pgsql-general by date:

Previous
From: Suzuki Hironobu
Date:
Subject: Re: psql client memory usage
Next
From: Tim Kane
Date:
Subject: Re: psql client memory usage