Sync replication + high latency server - Mailing list pgsql-general

From Edson Richter
Subject Sync replication + high latency server
Date
Msg-id COL131-W36040B2820B31C4E740D13CF7D0@phx.gbl
Whole thread Raw
Responses Re: Sync replication + high latency server
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Chars problem restoring to ps 8.4 (utf8) a dumped db from ps 8.1 (latin9)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Sync replication + high latency server