Using failover slots for PG-non_PG logical replication

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

Responses

Browse pgsql-hackers by date

  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