From: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> |
Subject: | Using failover slots for PG-non_PG logical replication |
Date: | 2025-07-02 05:20:09 |
Message-ID: | CAExHW5uiZ-fF159=jwBwPMbjZeZDtmcTbN+hd4mrURLCg2uzJg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
The failover slots documentation [1] is good for PG - PG logical
replication, but the first two queries require pg_subscription which
may not be present in non-PG downstream. Somebody looking to setup
failover slots for non-PG subscriber may not find the page useful.
However, the third query, when modified to mention the replication
slots relevant to the downstream is useful to them. How to find the
replication slots to be synchronized is a problem specific to the type
of downstream. Such a setup should add those slots to
sync_replication_slots. I think the chapter should mention that the
3rd query should also include the slots mentioned in
sync_replication_slots for PG-non_PG logical replication setup.
[1] https://www.postgresql.org/docs/current/logical-replication-failover.html
--
Best Wishes,
Ashutosh Bapat
From | Date | Subject | |
---|---|---|---|
Next Message | Shinya Kato | 2025-07-02 05:39:43 | Re: Extend COPY FROM with HEADER <integer> to skip multiple lines |
Previous Message | Michael Paquier | 2025-07-02 05:05:13 | Re: Decompression bug in astreamer_lz4 |