Re: Replication for R/W offline use - Mailing list pgsql-admin

From Greg Sabino Mullane
Subject Re: Replication for R/W offline use
Date
Msg-id 6db6f9bf7dfed39aef6ac959047d1343@biglumber.com
Whole thread Raw
In response to Replication for R/W offline use  (Gábor SZŰCS <surrano@gmail.com>)
Responses Re: Replication for R/W offline use
List 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.

http://bucardo.org/

- --
Greg Sabino Mullane greg@turnstep.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-----



pgsql-admin by date:

Previous
From: Gábor SZŰCS
Date:
Subject: Replication for R/W offline use
Next
From: Michael Clark
Date:
Subject: Re: Fix corrupt pg_toast table?