Re: Very asynchrnous replication system - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Very asynchrnous replication system
Date
Msg-id 356d425e32ac3d2b85585a43eee9862d@biglumber.com
Whole thread Raw
In response to Very asynchrnous replication system  (Laurent ROCHE <laurent_roche@yahoo.com>)
List pgsql-general
-----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-----



pgsql-general by date:

Previous
From: Laurent ROCHE
Date:
Subject: Re : Very asynchrnous replication system
Next
From: "Bima Djaloeis"
Date:
Subject: starting a stored procedure+rule AFTER an insert