Re: [GENERAL] How to check if any WAL file is missing in archive folder
On Fri, Sep 6, 2013 at 4:04 PM, Albe Laurenz wrote: > ascot.m...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to check if any WAL file is missing in archive folder
ascot.m...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to check if any WAL file is missing in archive folder
Hi, 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? regards -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general