Search Postgresql Archives

Re: Determining oldest WAL for Archiving PITR Standby - SOLVED

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux