| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Job <Job(at)colliniconsulting(dot)it> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replica on low-bandwitdh network |
| Date: | 2017-12-05 15:27:29 |
| Message-ID: | CAGrpgQ-795NNDdhVT9Bjc0=Sq=8Q6NLkzFY-jt8sb2GYUu9wPA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 5, 2017 at 1:12 AM, Job <Job(at)colliniconsulting(dot)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 (?)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugene Poole | 2017-12-05 18:59:26 | Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? |
| Previous Message | Melvin Davidson | 2017-12-05 14:03:59 | Re: [GENERAL] Schema Information . |