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-----
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 |