Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F20DC630749 for ; Fri, 9 Jan 2009 19:56:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50394-02 for ; Fri, 9 Jan 2009 19:56:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tinlc.com (unknown [72.18.206.65]) by mail.postgresql.org (Postfix) with ESMTP id 7F24B62DBE9 for ; Fri, 9 Jan 2009 19:56:53 -0400 (AST) Received: from biglumber.com ([72.18.206.64] helo=localhost) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1LLRDY-0008Tr-1e; Fri, 09 Jan 2009 18:56:44 -0500 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: suggestions/hints for multimaster solution X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <496727D0.9070801@transporeon.com> Date: Fri, 9 Jan 2009 23:56:43 -0000 X-Mailer: JoyMail 2.01 Message-ID: <048d07f4682c7d5bf5b24f66aaeb4602@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200901/29 X-Sequence-Number: 31076 -----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-----