I have a database with about 1 TB of data, mostly inserts, little updates and deletes, and I want to setup 2 logical replication for it. What should be my expectation with the replication?
1. What is the time-window that either of the nodes can be offline? - Will it survive if the node doing the publishing is offline for a few hours and then goes back online? - Will it survive if the subscriber node is offline for a few hours and then goes back online? 2. If the replication is aborted for whatever reason, is there a way to do it incrementally, or will it re-sync the 1TB at every such event? 3. What alternative tools are out there to e.g. periodically sync from one db to another? Thanks, Istvan
