Re: Replica on low-bandwitdh network

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Replica on low-bandwitdh network
Дата
Msg-id CAGrpgQ-795NNDdhVT9Bjc0=Sq=8Q6NLkzFY-jt8sb2GYUu9wPA@mail.gmail.com
обсуждение исходный текст
Ответ на Replica on low-bandwitdh network  (Job <Job@colliniconsulting.it>)
Список 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 по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] Schema Information .
Следующее
От: Eugene Poole
Дата:
Сообщение: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??