On 9 December 2011 18:46, Rob Sargent <robjsargent@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general