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@xxxxxxxxxxxxxxxxxxxx> 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
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.
