Could we go back in a replication slot?

From: xiong ding <dingxiong203(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Could we go back in a replication slot?
Date: 2024-09-02 01:48:52
Message-ID: CAP_sNCaSYLgZVYdT6u7c7CC8aA6CahsLui__ZpZzhsQks0bNew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Muhammad Ikram 2024-09-02 06:08:20 Re: Postgres Logical Replication - how to see what subscriber is doing with received data?
Previous Message Peter Geoghegan 2024-09-01 22:00:25 Re: PG17 optimizations to vacuum