Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint
Дата
Msg-id 87in18yxdf.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Adding a TAP test checking data consistency on standby withminRecoveryPoint  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
>>>>> "Michael" == Michael Paquier <michael@paquier.xyz> writes:

 Michael> I have also been trying to shape that into a TAP test which
 Michael> can be added into the in-core recovery test suite, and it
 Michael> happens that the part which scans if all the pages of a
 Michael> relation are not newer than what minRecoveryPoint is set to in
 Michael> the control file can be easily calculated by using pageinspect
 Michael> and pg_control_recovery() with a simple SQL query.

How? It's OK (and normal) for in-core pages to have newer LSNs than
minRecoveryPoint, it's only on-disk pages that must not be more recent
than that. And pageinspect will show the in-core page...

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: csv format for psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: jsonpath