Re: Is the a "magic number" for WAL files - Mailing list pgsql-general

From Thom Brown
Subject Re: Is the a "magic number" for WAL files
Date
Msg-id CAA-aLv6sVF2hk25BcOvbq=pxXYeYT3+PWsQS+hvXDsyPL+OZyA@mail.gmail.com
Whole thread Raw
In response to Is the a "magic number" for WAL files  (Rob Sargent <robjsargent@gmail.com>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: OT DBA type question - GRANT PRIVILEGE
Next
From: Andrew Sullivan
Date:
Subject: Re: OT DBA type question - GRANT PRIVILEGE