Re: Master-master replication with PostgreSQL

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Rob Collins <rob(dot)list(at)agiledata(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Master-master replication with PostgreSQL
Date: 2008-04-16 22:54:53
Message-ID: Pine.GSO.4.64.0804161829590.20928@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-04-17 01:43:05 Re: table as log (multiple writers and readers)
Previous Message Richard Broersma 2008-04-16 22:39:22 Re: ALTER TABLE DDL Triggers?