RE: Replica on low-bandwitdh network

From: "Ahmed, Nawaz" <Nawaz(at)fast(dot)au(dot)fujitsu(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Replica on low-bandwitdh network
Date: 2017-12-05 23:26:06
Message-ID: BAAE097528E6CB4FB2BE65AEFA6EEE047E4AA0D9@SYD1219
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You might as well try Slony.

Best Regards,

Nawaz Ahmed

-----Original Message-----
From: Job [mailto:Job(at)colliniconsulting(dot)it]
Sent: Tuesday, 5 December 2017 8:12 PM
To: pgsql-general(at)postgresql(dot)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), we think 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-confidence and 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 have received this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by 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 and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may result directly 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(at)fast(dot)au(dot)fujitsu(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message legrand legrand 2017-12-05 23:48:56 Re: Partition pruning / agg push down for star schema in pg v11
Previous Message Alvaro Herrera 2017-12-05 23:05:03 Re: a back up question