Looking for way to replicate master db to multiple mobile databases

From: Bryan Montgomery <monty(at)english(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Looking for way to replicate master db to multiple mobile databases
Date: 2009-09-23 17:11:31
Message-ID: ba6ead980909231011r28c145d6r331013d1fcbcf0bb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

However, I thought I'd see if anyone is doing something similar and what
thoughts there might be out there as to a better way to accomplish this.

Thanks,
Bryan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2009-09-23 17:23:21 Re: Source for CreatedSharedMemoryAndSemaphores
Previous Message Scott Marlowe 2009-09-23 17:05:43 Re: Help! Database restored with disabled triggers