From: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Very asynchrnous replication system |
Date: | 2007-10-06 00:25:16 |
Message-ID: | 688748.6664.qm@web34406.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Ben | 2007-10-06 00:49:59 | Re: Very asynchrnous replication system |
Previous Message | Benjamin Arai | 2007-10-05 22:57:31 | Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. |