Re: Master-master replication with PostgreSQL

From: "Rob Collins" <rob(dot)list(at)agiledata(dot)co(dot)uk>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Master-master replication with PostgreSQL
Date: 2008-04-17 11:33:13
Message-ID: fbaa2c1b0804170433p604e3a4br231e1c7d3acdb67c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gregsmith(dot)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_Poolingwhich 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

Browse pgsql-general by date

  From Date Subject
Next Message David Gagnon 2008-04-17 13:36:46 Unable to add a new column to a table named "in" (look like a bug ...)
Previous Message Paul Boddie 2008-04-17 11:06:57 Re: Which Python library - psycopg2 or pygresql?