Postgres Pro
Downloads
Home   >   mailing lists

Re: Master-master replication with PostgreSQL - Mailing list pgsql-general

From Rob Collins
Subject Re: Master-master replication with PostgreSQL
Date
Msg-id fbaa2c1b0804170433p604e3a4br231e1c7d3acdb67c@mail.gmail.com
Whole thread Raw
In response to Re: Master-master replication with PostgreSQL  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Tree view
Thanks everyone for your very helpful comments. I'm setting up some spikes to check performance and functionality of various alternatives.

Rob

On 16/04/2008, Greg Smith <gsmith@gregsmith.com> wrote:
On Wed, 16 Apr 2008, Rob Collins wrote:

My client has a flawed MS SQL Server system

 There's another kind?

From what I've read, Slony-I does only master-slave replication and Slony-II is not being actively developed. Is this right? Are there any viable master-master replication tools for PostgreSQL.

 Your later comments suggest you specifically need an asynchronous multi-master system, which rules out several suggestions.

I've been collecting information on this topic at http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling which you might find useful.  Nothing jumps out at me as being more appropriate for the situation you describe than Bucardo.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: String concat issues in 8.3.1 (8.3.1 bug?)
Next
From: Terry Lee Tucker
Date:
Subject: Duplicate Symbols - Compiler Warnings