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
adrian.klaver@aklaver.com
