Re: [Skytools-users] WAL Shipping + checkpoint

Поиск
Список
Период
Сортировка
От Martin Pihlak
Тема Re: [Skytools-users] WAL Shipping + checkpoint
Дата
Msg-id 4A96B01F.1020306@gmail.com
обсуждение исходный текст
Ответ на Re: [Skytools-users] WAL Shipping + checkpoint  (Sébastien Lardière <slardiere@hi-media.com>)
Ответы Re: [Skytools-users] WAL Shipping + checkpoint
Список pgsql-general
>> There are actually no "real" data changes being made on your master
>> for some reason. So every time archive_timeout is reached a log full
>> of no changes is shipped to your slave and applied - and no checkpoint
>> times are changed for reasons I mentioned above.
>>
>>
>
> thanks, but we have not set archive_timeout, and we have a lot of real
> data changes.
>
> That's why i don't understand why checkpoint never happen on the slave.
>

What about the other values in pg_controldata output, do they change at
all? If they remain constant, maybe the logs are just not applied. Also,
are there any "restored log file xxx from archive" entries in postgres
log?

regards,
Martin


В списке pgsql-general по дате отправления:

Предыдущее
От: Sualeh Fatehi
Дата:
Сообщение: Re: Schema diff tool?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Viable alternatives to SQL?