On 18-Oct-07, at 3:15 PM, Brian Wipf wrote:
The offset is the last 6 hex digits of the checkpoint location
value. The offset contains leading zeros to make it 6 digits if its
actual value is less than 6 digits. Therefore, the digits between
the slash and the last 6 digits are the log segment value. If there
are no digits between the slash and the last 6 hex digits, the log
segment value is simply 0.
If the checkpoint location is 2/3000020 and the timeline id is 1,
the corresponding WAL is 000000010000000200000000
Sorry, typo.
The corresponding WAL for a checkpoint location of 2/3000020 is
000000010000000200000003
Brian Wipf
ClickSpace Interactive Inc.
<brian@xxxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/