Re: Replica on low-bandwitdh network - Mailing list pgsql-general

From bricklen
Subject Re: Replica on low-bandwitdh network
Date
Msg-id CAGrpgQ-795NNDdhVT9Bjc0=Sq=8Q6NLkzFY-jt8sb2GYUu9wPA@mail.gmail.com
Whole thread Raw
In response to Replica on low-bandwitdh network  (Job <Job@colliniconsulting.it>)
List pgsql-general


On Tue, Dec 5, 2017 at 1:12 AM, Job <Job@colliniconsulting.it> wrote:
we have some postgreswl 9.6.1 servers in two different continent.
Latency is from 180 to 250 ms between the two sites.

Actually we use Rubyrep for off-site replication, since servers are completely independent in case of connectivity loss.

We are experiencing some problems with lock tables (rubyrep works with trigger to commit changes to the other server),
we think for the uncommon latency.

​You might get more mileage from pglogical (https://www.2ndquadrant.com/en/resources/pglogical/), which you can use to ship just the changes, though given my unfamiliarity with Rubyrep maybe that's what it does too (?)

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Schema Information .
Next
From: Eugene Poole
Date:
Subject: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??