Hi! On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery <monty@xxxxxxxxxxx> wrote: > Hi, > I'm looking for a way to replicate am master database to multiple (100+) > databases that are taken in to the field. Currently for each laptop we dump > and load the tables. However,there is only a small percentage of data that > changes on a frequent basis. > > I've been looking around and come across pyerplica, londiste and bucardo - > the documentation on most of these is fairly sparse. It seems that Bucardo > may be the best bet - at least initially. Bucardo is a good choice for this usage model because it was originally designed to work over a lossy network connections. You could issue 'kicks' for each laptop sync when you know for sure that a laptop has got an active network connection to your master. It's also pretty efficient with updates, only copying the current row (that's changed) a single time, rather than multiple times if there have been multiple changes to that row since the last time a sync occurred. -selena -- http://chesnok.com/daily - me http://endpoint.com - work -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
