Very asynchrnous replication system
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@u
The Computing Froggy
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
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:
Show quoted text
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 systemHave fun,
L@u
The Computing FroggyNe gardez plus qu'une seule adresse mail ! Copiez vos mails vers
Yahoo! Mail
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
I must replicate (or synchronise) data between disconnected
postgreSQL databases ... hence a replication "very asynchronous"!
Check out Bucardo (http://bucardo.org). It should be able to do
what you want with a "swap" sync (master-master). If the rows truly
do not overlap at all (by PK), you may also be able to set it up as a
dual "pushdelta" (master->slave both ways).
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200710080824
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFHCiHPvJuQZxSWSsgRA0/2AJ9MJOD8ekFHhvbwYgKZf+cV6ApSoACePl+O
+sOlZmm7JMAxnOowxJy3ux8=
=Bv0v
-----END PGP SIGNATURE-----