Thread: Re : Very asynchrnous replication system
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@u
The Computing Froggy
PS: I was away hence the delay in the reply.
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.
L@u
The Computing Froggy
PS: I was away hence the delay in the reply.
----- Message d'origine ----
De : Greg Sabino Mullane <greg@turnstep.com>
À : 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 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-----
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
De : Greg Sabino Mullane <greg@turnstep.com>
À : 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 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-----
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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 ! ! Sure, Bucardo could do that - just start Bucardo up when you want to do the sync, kick it off, and shut it down again before you disconnect from the network. Generally, you'd do this: Setup Bucardo on one side or the other (it does not matter which). Add the other database and tables, and describe what should be synced. This will setup the triggers on both sides. Turn Bucardo off. Start it up and do the sync when you have a connection. When the traveller wants to sync with the home base, they simply connect to the network, start up Bucardo and fire off the sync. Alternatively, if you don't want to install Bucardo on the remote computers, Bucardo could live on the "home" system, in which case it would startup there and fire off the sync when asked to. You could even run a single Bucardo instance on the home and toggle the databases from "active" to "inactive" status in the bucardo.db table. - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200710151116 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFHE4ROvJuQZxSWSsgRA0ytAKD7mKsjuPVb1o5q1It+ytayPnpVCwCgz4OD lOn8974pHWIMKLrBwuaJwWI= =79Av -----END PGP SIGNATURE-----