pgsql: Add TAP test to check consistency of minimum recovery LSN

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Add TAP test to check consistency of minimum recovery LSN
Дата
Msg-id E1h3wzS-00059D-Vn@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Add TAP test to check consistency of minimum recovery LSN

c186ba13 has fixed an issue related to the updates of the minimum
recovery LSN across multiple processes on standbys, but we never really
had a test case able to reliably check its logic.

This commit introduces a new test case to close the gap, and is designed
to check the consistency of data based on the minimum recovery point set
by either the startup process or the checkpointer for both an offline
cluster (by looking at the on-disk page headers) and an online cluster
(using pageinspect).

Note that with c186ba13 reverted, this test fails badly for both the
online and offline cases, as designed.

Author: Michael Paquier, Andrew Gierth
Reviewed-by: Andrew Gierth, Georgios Kokolatos, Arthur Zakirov
Discussion: https://postgr.es/m/20181108044525.GA17482@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b0825d28ea83e44139bd319e6d1db2c499cd4c6a

Modified Files
--------------
src/test/perl/TestLib.pm                   |  11 ++
src/test/recovery/Makefile                 |   2 +-
src/test/recovery/t/016_min_consistency.pl | 175 +++++++++++++++++++++++++++++
3 files changed, 187 insertions(+), 1 deletion(-)


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Rename pg_verify_checksums to pg_checksums
Следующее
От: Magnus Hagander
Дата:
Сообщение: pgsql: Remove extra comma