Re: Determining oldest WAL for Archiving PITR Standby - SOLVED

Поиск
Список
Период
Сортировка
От Brian Wipf
Тема Re: Determining oldest WAL for Archiving PITR Standby - SOLVED
Дата
Msg-id 9C38B621-6D80-449F-8958-9235B11BD611@clickspace.com
обсуждение исходный текст
Ответ на Re: Determining oldest WAL for Archiving PITR Standby - SOLVED  (Brian Wipf <brian@clickspace.com>)
Список 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 по дате отправления:

Предыдущее
От: Laurent ROCHE
Дата:
Сообщение: Re : Re : Resetting SEQUENCEs
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Re : Abbreviation list