Hi, Bucardo is an interesting project (they've just released a new version) but id does not look like they are able to perform delayed (or very asynchronous) replication: from the information I could gathered Bucardo replicates between databases always connected to each other. When I want to replicate between "not always on" databases ! !
Thanks for the indication anyway. Cheers, [EMAIL PROTECTED] The Computing Froggy PS: I was away hence the delay in the reply. ----- Message d'origine ---- De : Greg Sabino Mullane <[EMAIL PROTECTED]> À : pgsql-general@postgresql.org Envoyé le : Lundi, 8 Octobre 2007, 14h27mn 03s Objet : Re: [GENERAL] Very asynchrnous replication system -----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 [EMAIL PROTECTED] 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----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
