pgsql: Add TAP test to check consistency of minimum recovery LSN - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Add TAP test to check consistency of minimum recovery LSN
Date
Msg-id E1h3wzS-00059D-Vn@gemulon.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Rename pg_verify_checksums to pg_checksums
Next
From: Magnus Hagander
Date:
Subject: pgsql: Remove extra comma