Re: suggestions/hints for multimaster solution - Mailing list pgsql-admin

From Greg Sabino Mullane
Subject Re: suggestions/hints for multimaster solution
Date
Msg-id 048d07f4682c7d5bf5b24f66aaeb4602@biglumber.com
Whole thread Raw
In response to suggestions/hints for multimaster solution  (Gerd König <koenig@transporeon.com>)
List 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@turnstep.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-----



pgsql-admin by date:

Previous
From: dx k9
Date:
Subject: initdb Q rewritten please remove or ignore my last email
Next
From: Jan-Peter.Seifert@gmx.de
Date:
Subject: PGOPTIONS and default_tablespace