Hi!
I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when network is under load). Considering that I will keep enough WAL files (let's say, 200 WAL segments on a server with low write rate): What happens if I configure timeout in master server for, let's say, 10 seconds? Will sync replication survive if timeout happens, and then, network "recover" it self? Or will I be obligated to use async replication in such scenario? I'll appreciate your expert insight. Thanks, Edson |