Re: Master-master replication with PostgreSQL

Rob Collins escribió:
> Hello
>
> We're looking for an open-source database solution that has a Python
> interface and will do master-master replication. My client has a
> flawed MS SQL Server system, with the replication hand-coded in
> Python. They don't want to pay very high licence fees for the MS SQL
> Server Enterprise version at 20 sites across the UK.
>
> There is one central server with 19 branches. Some tables need to
> replicate from the central server to the branches. Other tables are
> centralised from the branches into one totalling table at the centre.
> A few tables need to replicate in both directions.
>
> 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. (They could be
> commercial/paid for if necessary.)
>
> Rob
I am testing bucardo (http://www.bucardo.org) in star replication with
one office at Canada and 3 branches in different countries and it's
working really nice. It's not yet in production, but my test show that
it's really good for star replication as you need.

BTW, my replication is bi-directional and all the branches syncronized
with the others.

Rodrigo