| 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 |
| 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 |