Re: Very asynchrnous replication system

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Very asynchrnous replication system
Date: 2007-10-08 12:27:03
Message-ID: 356d425e32ac3d2b85585a43eee9862d@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-10-08 13:00:47 Re: Problem with SELECT
Previous Message marwis1978 2007-10-08 10:28:04 Problem with SELECT