Re: Looking for way to replicate master db to multiple mobile databases

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Selena Deckelmann <selenamarie(at)gmail(dot)com>, Bryan Montgomery <monty(at)english(dot)net>
Subject: Re: Looking for way to replicate master db to multiple mobile databases
Date: 2009-09-24 15:27:33
Message-ID: 20090924152733.GC5554@eddie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 24, 2009 at 05:09:26PM +0200, Cédric Villemain wrote:
> > Bucardo is a good choice for this usage model because it was
> > originally designed to work over a lossy network connections.
>
> yes, but isn't bucardo designed to 2 nodes only ?

Bucardo's multi-master replication works only between two hosts, unless
perhaps you can assure that only certain primary keys will be updated on
certain hosts, or do some other trickery. Syncing from one master to multiple
slaves is straightforward, if all you need is master->slave.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message agostonbejo 2009-09-24 15:35:30 Re: How to have ant's <sql> task insert special chars appropriately?
Previous Message Cédric Villemain 2009-09-24 15:09:26 Re: Looking for way to replicate master db to multiple mobile databases