Re: Determining oldest WAL for Archiving PITR Standby - SOLVED

From: Brian Wipf <brian(at)clickspace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Determining oldest WAL for Archiving PITR Standby - SOLVED
Date: 2007-10-18 21:34:18
Message-ID: 9C38B621-6D80-449F-8958-9235B11BD611@clickspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)clickspace(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-10-18 21:44:39 Re: Re : Abbreviation list
Previous Message Laurent ROCHE 2007-10-18 21:32:59 Re : Re : Resetting SEQUENCEs