| From: | Ajin Cherian <itsajin(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Improve pg_sync_replication_slots() to wait for primary to advance |
| Date: | 2025-06-24 10:40:58 |
| Message-ID: | CAFPTHDZAA+gWDntpa5ucqKKba41=tXmoXqN3q4rpjO9cdxgQrw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
Creating this thread for a POC based on discussions in thread [1].
Hou-san had created this patch, and I just cleaned up some documents,
did some testing and now sharing the patch here.
In this patch, the pg_sync_replication_slots() API now waits
indefinitely for the remote slot to catch up. We could later add a
timeout parameter to control maximum wait time if this approach seems
acceptable. If there are more ideas on improving this patch, let me
know.
regards,
Ajin Cherian
[1] - https://www.postgresql.org/message-id/CAF1DzPWTcg%2Bm%2Bx%2BoVVB%3Dy4q9%3DPYYsL_mujVp7uJr-_oUtWNGbA%40mail.gmail.com
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Fix-stale-snapshot-issue.patch | application/octet-stream | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ajin Cherian | 2025-06-24 10:48:18 | Re: Improve pg_sync_replication_slots() to wait for primary to advance |
| Previous Message | Amit Kapila | 2025-06-24 10:29:15 | Re: Improve doc on parallel stream changes for Stream Abort message |