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