Re: Sync replication + high latency server

On 08/12/2015 05:33 PM, Edson Richter wrote:
> 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?

I think you are misunderstanding how sync rep works.

>
> Or will I be obligated to use async replication in such scenario?
>

async is your friend here.

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.