Re: suggestions/hints for multimaster solution

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: suggestions/hints for multimaster solution
Date: 2009-01-09 23:56:43
Message-ID: 048d07f4682c7d5bf5b24f66aaeb4602@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> we're looking for a multi-master solution (whole database not only some
> tables) for our production database (Postgres 8.3.5 64bit on OpenSuse),
> and I wanted to know what are your experiences/suggestions with/for such
> a scenario (multimaster for failover purpose).
> I know there are some tools, but :
> * bucardo -> not for failover

Not sure what you mean by failover in this context, as a true multi-master
solution does not need failover as there are always two or more nodes
that are read/write at the same time. (Bucardo probably fails your other
requirement though, of non-table items, as it does not do DDL).

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200901091856
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkln5C8ACgkQvJuQZxSWSsg2fgCgxCwxWMh/kNKpP5A8q8Pg3ajD
K6cAoMn8YjfuMHP0t72DS6TIr7v/3jl5
=uZwi
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jan-Peter.Seifert 2009-01-12 09:34:27 PGOPTIONS and default_tablespace
Previous Message dx k9 2009-01-09 21:20:14 initdb Q rewritten please remove or ignore my last email