Re: The sequence of WALs to be replayed

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: The sequence of WALs to be replayed
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B50FA6FD3@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на The sequence of WALs to be replayed  (Shih Théo <galaxyshih@gmail.com>)
Список pgsql-admin
Shih Théo wrote:
> I am using postgres incremental backup for quite a month. Every thing so far works great for me.
> However, one thing confuses me. That is the sequence of how WALs to be replayed.
> I know I can read this information when I turn on the log function but the sequence inside is not so
> clear especially when the amount of WALs is quite large.
> I need to know this information because I need to estimate how long does each restore take.
> Could somebody help me please.

The WAL segments are procesed in order, and that is the name of the file
interpreted as hex number (I'm ignoring the issue of timelines here).

You should be able to figure out the starting WAL segment from the
backup.label file in the backup.

Does that help?

Yours,
Laurenz Albe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jan Harasym
Дата:
Сообщение: Re: pgAgent issue on redhat 6.5 for newbie
Следующее
От: "HEARNE, TIMOTHY S"
Дата:
Сообщение: Need to calculate PostgreSQL memory usage