Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replica on low-bandwitdh network

Replica on low-bandwitdh network

From
Job
Date:
Hi guys,

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.

Which is, for you, the best replication module for Postgresql?
Bucardo? Something else?

Thank you, very best!
F

Re: Replica on low-bandwitdh network

From
bricklen
Date:


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 (?)

RE: Replica on low-bandwitdh network

From
"Ahmed, Nawaz"
Date:
You might as well try Slony.

Best Regards,

Nawaz Ahmed




-----Original Message-----
From: Job [mailto:Job@colliniconsulting.it]
Sent: Tuesday, 5 December 2017 8:12 PM
To: pgsql-general@postgresql.org
Subject: Replica on low-bandwitdh network

Hi guys,

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),
wethink for the uncommon latency.
 

Which is, for you, the best replication module for Postgresql?
Bucardo? Something else?

Thank you, very best!
F

Disclaimer

The information in this e-mail is confidential and may contain content that is subject to copyright and/or is
commercial-in-confidenceand is intended only for the use of the above named addressee. If you are not the intended
recipient,you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you
havereceived this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000
orby reply e-mail to the sender and delete the document and all copies thereof.
 


Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email
communication,it is the receiver’s responsibility to scan all communication and any files attached for computer viruses
andother defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage
(whetherdirect, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may
resultdirectly or indirectly from this communication or any files attached.
 


If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty
Ltd,please email unsubscribe@fast.au.fujitsu.com

Re: Replica on low-bandwitdh network

From
Ben Madin
Date:
I don't know if this is relevant, but we use the default streaming replication and were not always keeping up. Now we WAL log ship to S3 bucket... seems to work pretty well... cheers Ben

On 5 December 2017 at 17:12, Job <Job@colliniconsulting.it> wrote:
Hi guys,

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.

Which is, for you, the best replication module for Postgresql?
Bucardo? Something else?

Thank you, very best!
F




--

Dr Ben Madin



m : +61 448 887 220


5 Shuffrey Street, Fremantle
Western Australia

on the web: www.ausvet.com.au


This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this email are the opinion of the writer only and are not endorsed by Ausvet unless expressly stated otherwise. Although Ausvet uses virus scanning software we do not accept liability for viruses or similar in any attachments.