Could we go back in a replication slot? - Mailing list pgsql-general

From xiong ding
Subject Could we go back in a replication slot?
Date
Msg-id CAP_sNCaSYLgZVYdT6u7c7CC8aA6CahsLui__ZpZzhsQks0bNew@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi, community,

The START_REPLICATION command accepts a lsn parameter, but according to the document that replication "starts at either WAL location XXX/XXX or the slot's confirmed_flush_lsn (see Section 54.19), whichever is greater." I wonder if there is a way to go back, like a command to set confirmed_flush_lsn to a previous lsn.

I am asking because I may need to replay the replication messages to Kafka.

Sincerely,
Xiong Ding
 

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: PG17 optimizations to vacuum
Next
From: Muhammad Ikram
Date:
Subject: Re: Postgres Logical Replication - how to see what subscriber is doing with received data?