There is no multi master solution for PostgreSQL - at all AFAIK.  What 
you want is impossible unless you wait no small amount of time for Slony II.

Chris


Andy wrote:
> Well, everybody's in vacation (I hope so) or there is no solution for me???
> 
> Best regards,
> Andy.
> 
> 
> ----- Original Message ----- From: "Andy" <frum at ar-sd.net>
> To: "Scott Marlowe" <smarlowe at g2switchworks.com>
> Cc: <slony1-general at gborg.postgresql.org>
> Sent: Friday, July 22, 2005 9:46 AM
> Subject: Re: [Slony1-general] Slony >> Multi Master Replication???
> 
> 
>>> 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.
>>>
>>>
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>>
>>
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general