Add TAP tests to check replication slot advance during the checkpoint
authorAlexander Korotkov <[email protected]>
Sat, 14 Jun 2025 00:35:27 +0000 (03:35 +0300)
committerAlexander Korotkov <[email protected]>
Sat, 14 Jun 2025 00:55:21 +0000 (03:55 +0300)
commiteb124c3d6deb5d0c7a588d847e3840bcc2cd0dcc
treefc190248910f2587e3d24a7c1cc158d66425d7c9
parentca307d5cec90a4fde62a50fafc8ab607ff1d8664
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 <[email protected]>
Author: Tomas Vondra <[email protected]>
Reviewed-by: Alexander Korotkov <[email protected]>
Reviewed-by: Amit Kapila <[email protected]>
Backpatch-through: 17
src/backend/access/transam/xlog.c
src/backend/replication/logical/logical.c
src/test/recovery/meson.build
src/test/recovery/t/046_checkpoint_logical_slot.pl [new file with mode: 0644]
src/test/recovery/t/047_checkpoint_physical_slot.pl [new file with mode: 0644]