#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2011
    Posts
    13
    Rep Power
    0

    Synchronising PostgreSQL Databases


    I have a situation where I have a database of patients that require house visits. Every morning I want to give 10 different fieldworkers a copy of this master database for them to go out into the field with. On returning in the evening, I will expect that they will have registered new patients as well as updated some. At the end of the day then, I would like each of the 10 fieldworkers to update the central master database with their inserts and updates. How can this be done in PostgreSQL?

    Thanks in advance,
    Tumaini
  2. #2
  3. No Profile Picture
    I haz teh codez!
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2003
    Posts
    2,556
    Rep Power
    2338
    You could try Bucardo. Or Slony-I.
    I ♥ ManiacDan & requinix

    This is a sig, and not necessarily a comment on the OP:
    Please don't be a help vampire!

IMN logo majestic logo threadwatch logo seochat tools logo