Rodrigo Gonzalez escribió:
> Using star replication I have all the nodes as master....so n
> master-master replication with the common DB as master to all the nodes
> and all the nodes as master to the common DB

Oh, so the Bucardo docs are incorrect.

http://www.bucardo.org/bucardo.html#BucardoLimitations



--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Rodrigo Gonzalez escribió:
> Yes and no....
>
> bucardo cannot handle master-master-master
>
> What I am doing is
>
> masterA-masterB
> masterA-masterC
> masterA-masterD

Oh, I see -- makes sense. Quite misleading docs, then.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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/Repl...tion_Poolin g
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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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@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/Repl...Poolin gwhich 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
>