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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: How to check if any WAL file is missing in archive folder
Дата
Msg-id CAB7nPqT4u6VmFX9HvEFMpHQMBUMSXW+dKzVtdPYTzaHqJQpm3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check if any WAL file is missing in archive folder  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Suzuki Hironobu
Дата:
Сообщение: Re: psql client memory usage
Следующее
От: Tim Kane
Дата:
Сообщение: Re: psql client memory usage