From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Replication for R/W offline use |
Date: | 2009-07-31 18:00:16 |
Message-ID: | 6db6f9bf7dfed39aef6ac959047d1343@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> - Way of handling conflicting records
> e.g. client A goes offline, client B modifies master, client A
> modifies locally, and when goes online again cannot commit the
> changes.
One possible solution you should look at is Bucardo, which
does master-master replication. One of the tricky parts you
might want to reconsider though is:
> The difference is that I do not know when will the client go offline,
> even client does not know (e.g. ISP goes down) and, of course, there
> may be a lot of connections while client is offline.
This says to me that you should simply make all writes go to the
local box, and have Bucardo keep trying to keep things in sync.
If it can connect, great. If not, it dies and tries again later.
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200907311359
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkpzMSsACgkQvJuQZxSWSsgpoQCgrNa9PFxtVvKcljTguCCvmN6E
HnkAn3OzYFCJZeR7vvhC9Hr/+DVs9tir
=+Tr0
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Clark | 2009-07-31 19:01:16 | Re: Fix corrupt pg_toast table? |
Previous Message | Gábor SZŰCS | 2009-07-31 14:17:32 | Replication for R/W offline use |