Re: Master-master replication with PostgreSQL

From: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Julio Cesar Sánchez González <knowhow(at)sistemasyconectividad(dot)com(dot)mx>, Rob Collins <rob(dot)list(at)agiledata(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Master-master replication with PostgreSQL
Date: 2008-04-16 16:53:32
Message-ID: 48062F0C.8030605@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Alvaro Herrera escribió:
> Julio Cesar Sánchez González wrote:
>
>> El mié, 16-04-2008 a las 12:13 +0100, Rob Collins escribió:
>>
>
>
>>> 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.
>>>
>> Try with bucardo ("http://bucardo.org/") may be help you :).
>>
>
> Unfortunately, Bucardo only seems to work with 2 masters -- you can't
> have 20.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave 2008-04-16 16:58:39 How do I measure user disk usage on Postgresql table?
Previous Message Craig Ringer 2008-04-16 16:35:33 Re: table as log (multiple writers and readers)