Add TAP tests to check replication slot advance during the checkpoint
authorAlexander Korotkov
Sat, 14 Jun 2025 00:35:27 +0000 (03:35 +0300)
committerAlexander Korotkov
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 
Author: Tomas Vondra 
Reviewed-by: Alexander Korotkov
Reviewed-by: Amit Kapila
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]