Re: Determining oldest WAL for Archiving PITR Standby - SOLVED - Mailing list pgsql-general

From Brian Wipf
Subject Re: Determining oldest WAL for Archiving PITR Standby - SOLVED
Date
Msg-id 9C38B621-6D80-449F-8958-9235B11BD611@clickspace.com
Whole thread Raw
In response to Re: Determining oldest WAL for Archiving PITR Standby - SOLVED  (Brian Wipf <brian@clickspace.com>)
List pgsql-general
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@clickspace.com>



pgsql-general by date:

Previous
From: Laurent ROCHE
Date:
Subject: Re : Re : Resetting SEQUENCEs
Next
From: Raymond O'Donnell
Date:
Subject: Re: Re : Abbreviation list