Re: How to check if any WAL file is missing in archive folder

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: "ascot(dot)moss(at)gmail(dot)com *EXTERN*" <ascot(dot)moss(at)gmail(dot)com>, pgsql-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to check if any WAL file is missing in archive folder
Date: 2013-09-06 13:16:42
Message-ID: CAB7nPqT4u6VmFX9HvEFMpHQMBUMSXW+dKzVtdPYTzaHqJQpm3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 6, 2013 at 4:04 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> ascot(dot)moss(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Kane 2013-09-06 13:19:42 Re: psql client memory usage
Previous Message Suzuki Hironobu 2013-09-06 13:11:03 Re: psql client memory usage