From: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re : Very asynchrnous replication system |
Date: | 2007-10-15 08:31:50 |
Message-ID: | 941786.23299.qm@web34409.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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,
L(at)u
The Computing Froggy
PS: I was away hence the delay in the reply.
----- Message d'origine ----
De : Greg Sabino Mullane <greg(at)turnstep(dot)com>
À : pgsql-general(at)postgresql(dot)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 greg(at)turnstep(dot)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-----
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-10-15 08:41:25 | Re: Using case expressions in update set clause |
Previous Message | Albe Laurenz | 2007-10-15 08:08:21 | Re: CHAR SETS |