Merge requirements between offline clients and central database

From: Sameer Thakur <samthakur74(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Merge requirements between offline clients and central database
Date: 2014-09-04 07:01:52
Message-ID: CABzZFEvWoqdW6RsoNZpdiv8baBVks3S9-yAxi8yWE86s5k92CQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
As part of database evaluation one key requirements is as follows:

1. There are multiple thick clients (say 20 ~ 100) with their local
databases accepting updates
2. They sync data with a central database which can also receive updates itself.
3. They may not be connected to central database all the time.
4. The central database receives and merges client data, but does not
push data back to clients i.e. data between clients is not synced via
central database or any other way.
Is there anyway PostgreSQL, with any open source tool, can support
such a scenario? How close can it be met?
Any suggestions perhaps on a building a tool outside core which could
bridge any gaps would help too
Thank you
Sameer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Giuseppe Broccolo 2014-09-04 07:42:15 Re: GiST index question
Previous Message Vinayak 2014-09-04 05:48:52 Re: || operator