> Well, there's always some kludgy answer to such problems.  But, are you
> sure you really need true multi-master replication?  Mayhaps you could
> describe what it is you are trying to do first, then allow the group to
> help you come up with an answer.
Ok. Here is my story:

We develop a contract management software, we use a Postgre database, which 
has around 100 tables. Our compnay wants so open 2 more offices(in 
September) in Europe where the employees will have to work with this 
management software. And we are looking for a solution that we can install 
this software on local servers in this offices.

In this offices will be performed some major tasks like: add a contract, 
planifications, report writings etc. We already use Slony for a datatransfer 
to a client, but he can only read the data's and it is ok so. But in this 
offices will be a lot of writing in the database. That is why I wanted a 
multi master replications. Most of the tables are "static" tables. I mean 
that they contain lists... that somehow are "fix"... can be user as 
"read_only" in these offices. But a task like: add a contract writes data in 
at least 8 tables, planning in 3, report writing in 6 or 7 didn't count them 
exactly.

So, my problem is this: how to replicate the database and also keep these 
tables "writable"??? The solution that I see is to duplicate these tables 
and replicate them reversily(from slave to master) and to read the data with 
scripts... but somehow I don't like it very much. The other problem with 
this solution is that we'll have 2 offices now... what about the future...

I will appriciate any ideeas, solutions etc.

Best regards,
Andy.


----- Original Message ----- 
From: "Scott Marlowe" <smarlowe at g2switchworks.com>
To: "Andy" <frum at ar-sd.net>
Cc: <slony1-general at gborg.postgresql.org>
Sent: Thursday, July 21, 2005 7:04 PM
Subject: Re: [Slony1-general] Slony >> Multi Master Replication???


> On Thu, 2005-07-21 at 05:05, Andy wrote:
>> I know that with Slony I is not possible to make a multi master
>> replication.
>>
>> Probably some of you have more experience with Postgre Replication and
>> I really need to make a multi master replication. I heard that slony
>> II will be able to do this... but I don't know iof there is any
>> release date or somthing more specific about it.
>>
>> Or... other replication solution?
>>
>
> Well, there's always some kludgy answer to such problems.  But, are you
> sure you really need true multi-master replication?  Mayhaps you could
> describe what it is you are trying to do first, then allow the group to
> help you come up with an answer.  There may be an inobvious fix no one
> will think of until they know what objectives you're trying to reach.
>
>