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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
