| From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Sync replication + high latency server |
| Date: | 2015-08-13 00:33:48 |
| Message-ID: | COL131-W36040B2820B31C4E740D13CF7D0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2015-08-13 03:40:46 | Re: Sync replication + high latency server |
| Previous Message | Tom Lane | 2015-08-12 14:12:15 | Re: Chars problem restoring to ps 8.4 (utf8) a dumped db from ps 8.1 (latin9) |