Using failover slots for PG-non_PG logical replication
Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>,
Amit Kapila <amit.kapila16@gmail.com>
Cc: Ashutosh Sharma <ashu.coek88@gmail.com>
Date: 2025-07-02T05:20:09Z
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
Commits
-
Doc: Improve logical replication failover documentation.
- 5d9e675b36b5 18.0 landed
- 24f608625f9a 19 (unreleased) landed
- f2e41d9e2fb0 17.6 landed