Re: Is the a "magic number" for WAL files

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Is the a "magic number" for WAL files
Дата
Msg-id CAA-aLv6sVF2hk25BcOvbq=pxXYeYT3+PWsQS+hvXDsyPL+OZyA@mail.gmail.com
обсуждение исходный текст
Ответ на Is the a "magic number" for WAL files  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
On 9 December 2011 18:46, Rob Sargent <robjsargent@gmail.com> wrote:
> Along the same lines, what info is embedded in the file name? I see that
> the second non-zero recently went from 2 to 3.  Significance?
>
>
> 0000000100000030000000CF
>              ^
> --------------|

The WAL file name consists of timeline, segment set/segment block and
segment,  Once the segment (the last 8 characters of the file name)
reaches 000000FE, the next file will have a segment 00000000 but
characters 9-16 will increment their value to reflect this wraparound.
 So it's not any more significant that 1 added to 99 results in it
becoming 00 with a 1 before it.

--
Thom

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: OT DBA type question - GRANT PRIVILEGE
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: OT DBA type question - GRANT PRIVILEGE