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 descriptionThis 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@uThe Computing Froggy
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail