Re: Replication slot is not able to sync up

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Replication slot is not able to sync up
Date: 2025-05-27 05:50:39
Message-ID: CAJpy0uB9ipTr1+4Lb2pfw9483b7zQa1so7YaBeDcA_z9yqvOiw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 26, 2025 at 12:02 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> Agree that log messages need improvement. Please find the patch
> attached for the same. I also intend to update the docs in this area
> for users to understand this feature better, and will work on that
> soon.
>

PFA the patch with doc changes as well. The doc explains the need of
pg_logical_slot_get_changes() for a particular scenario.

Also attached the script to show how this setup works. When the
replication slot is being actively consumed on primary, we do not
observe that particular LOG (could not synchronize replication) on
standby and synchronization proceeds without any manual intervention.

Thanks Nisha for the script.

thanks
Shveta

Attachment Content-Type Size
v2-0001-Improve-log-messages-and-docs-for-slotsync.patch application/octet-stream 5.2 KB
test_slotsync.sh text/x-sh 5.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2025-05-27 06:00:01 Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION
Previous Message Pavel Stehule 2025-05-27 05:30:00 Re: Avoiding memory leak when compilation of a function fails