On 11/6/25 16:30, Bala M wrote:
*
*
*1) Show how you have set up the publishers and subscribers.*
We have configured logical replication between PostgreSQL 11 (publisher)
and PostgreSQL 16 (subscriber).
Publisher: PostgreSQL 11 with wal_level=logical,
max_replication_slots=20, and publication created for all tables (FOR
ALL TABLES).
I have not worked with a database of this size, still I would think FOR
ALL TABLES is not the way to go. That it along with the existing
activity on the publisher would result in a slow transfer of data.
--
Adrian Klaver
[email protected]
