pgsql: Add TAP tests to check replication slot advance during the check - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Add TAP tests to check replication slot advance during the check
Date
Msg-id E1uQFhw-001YD7-22@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add TAP tests to check replication slot advance during the checkpoint

The new tests verify that logical and physical replication slots are still
valid after an immediate restart on checkpoint completion when the slot was
advanced during the checkpoint.

This commit introduces two new injection points to make these tests possible:

* checkpoint-before-old-wal-removal - triggered in the checkpointer process
  just before old WAL segments cleanup;
* logical-replication-slot-advance-segment - triggered in
  LogicalConfirmReceivedLocation() when restart_lsn was changed enough to
  point to the next WAL segment.

Discussion: https://postgr.es/m/flat/1d12d2-67235980-35-19a406a0%4063439497
Author: Vitaly Davydov <v.davydov@postgrespro.ru>
Author: Tomas Vondra <tomas@vondra.me>
Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Backpatch-through: 17

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/32ab0fd55da5b667a25e56bd74e258bb8eca6cf3

Modified Files
--------------
src/backend/access/transam/xlog.c                  |   4 +
src/backend/replication/logical/logical.c          |  18 +++
src/test/recovery/meson.build                      |   2 +
src/test/recovery/t/046_checkpoint_logical_slot.pl | 139 +++++++++++++++++++++
.../recovery/t/047_checkpoint_physical_slot.pl     | 133 ++++++++++++++++++++
5 files changed, 296 insertions(+)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Keep WAL segments by slot's last saved restart LSN
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Keep WAL segments by the flushed value of the slot's restart LSN