Re: Replication for R/W offline use

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Replication for R/W offline use
Дата
Msg-id 6db6f9bf7dfed39aef6ac959047d1343@biglumber.com
обсуждение исходный текст
Ответ на Replication for R/W offline use  (Gábor SZŰCS <surrano@gmail.com>)
Ответы Re: Replication for R/W offline use  (Gábor SZŰCS <surrano@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Gábor SZŰCS
Дата:
Сообщение: Replication for R/W offline use
Следующее
От: Michael Clark
Дата:
Сообщение: Re: Fix corrupt pg_toast table?