From: | Ben <bench(at)silentmedia(dot)com> |
---|---|
To: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Very asynchrnous replication system |
Date: | 2007-10-06 00:49:59 |
Message-ID: | 3E9A7EB3-B4B4-4DA6-9CDC-DFDA08500760@silentmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The MusicBrainz project replicates in a way that sounds like it could
fit your needs. It depends on a lot of perl, but if that's not a
showstopper, then maybe adapting their replication scheme would work
for you.
On Oct 5, 2007, at 5:25 PM, Laurent ROCHE wrote:
> Hello,
>
> I must replicate (or synchronise) data between disconnected
> postgreSQL databases ... hence a replication "very asynchronous"!
>
> Application description
> This an application to manage sales forces with a central
> application (and postgreSQL server) where everybody in the office
> can connect (this a web application: Tomcat with Spring 2+ Struts 2
> + iBatis + PostgreSQL).
> But there are also "little itinerant applications": the sales rep
> have the application on their laptop and a PosgreSQL server with a
> copy of the data (they are interested in ) from the main server
> database.
> From time to time, the sales reps connect to the internet and
> request a data synchronisation: they send their modification and
> receive the headquarters modification.
> (no problem about data overlap: the data owner is clearly
> identified by the application framework)
>
> My problem:
> Does such an existing system (the replication one) exist ?
> I search the web I did not find anything !
> I have started to do something (with triggers, log table and table
> export - using DDL-Utils) ... but looking at the spreadth of the
> task layed out in front of me, I am thinking that I will be better
> off using or adapting an existing replication system
>
>
> Have fun,
> L(at)u
> The Computing Froggy
>
>
> Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers
> Yahoo! Mail
From | Date | Subject | |
---|---|---|---|
Next Message | Goboxe | 2007-10-06 10:34:23 | Re: Partitioned tables, rules, triggers |
Previous Message | Laurent ROCHE | 2007-10-06 00:25:16 | Very asynchrnous replication system |