Sync replication + high latency server

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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)