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

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "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 07:04:40
Message-ID: A737B7A37273E048B164557ADEF4A58B17C1B30B@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2013-09-06 07:30:36 Re: Levenshtein Distance with more than 255 characters
Previous Message Tom Lane 2013-09-06 06:47:34 Re: Levenshtein Distance with more than 255 characters