Thread: Question about Logical Replication
Hello. Do I need to configure the settings (max_replication_slots , max_wal_senders, etc) according to the number of tables to be replicated? Thanks
Hello.
Do I need to configure the settings (max_replication_slots , max_wal_senders, etc) according to the number of tables to be replicated?
In short, no. The determination of values for these settings is based upon other aspects of the overall multi-server system.
Physical replication is cluster-based, not table based. The slots/senders are roughly the number of servers involved in the setup.
Logical replication is publication based.
"A publication is a set of changes generated from a table or a group of tables, and might also be described as a change set or replication set. Each publication exists in only one database."
The slots/senders are consumed as servers subscribe to publications.
David J.
Thank you David.
So the defaults are fine for me since I will only have 1 subscriber.
Thanks again!
El 11/12/2017 a las 01:42 p. m., David G. Johnston escribió:
Hello.
Do I need to configure the settings (max_replication_slots , max_wal_senders, etc) according to the number of tables to be replicated?In short, no. The determination of values for these settings is based upon other aspects of the overall multi-server system.Physical replication is cluster-based, not table based. The slots/senders are roughly the number of servers involved in the setup.Logical replication is publication based."A publication is a set of changes generated from a table or a group of tables, and might also be described as a change set or replication set. Each publication exists in only one database."The slots/senders are consumed as servers subscribe to publications.David J.