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
0001-Fix-stale-snapshot-issue.patch
Description: Binary data
