| 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: | Whole Thread | Raw Message | 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 |