Jan Wieck wrote:
> On 9/5/2004 2:21 AM, George McQuade wrote:
>>
>> The customer has 3 branch locations 1,2 and 3 which originate the data.
>> He also has a fourth "home office" location which would like to see all
>> the data agregated from locations 1,2 and 3 for reporting purposes. No
>> writing is allowed in home office location 4.
>>
>> All primary keys take into account a companyid of 1,2 or 3 to guarantee
>> uniqueness at location 2.

> 
> This sort of configuration is not planned, and I think the concepts 
> behind Slony-I will give you a really hard time to even incorporate it 
> on a theoretical base.
> 
> Remembering what Robert Kaye had presented at OSCON, either dbmirror or 
> the system he has derived from it seems to be a good point to start from 
> for you.

I agree 100%. We wrote an application where I work, that works almost 
identically to what George describes above, and we have been 
successfully using dbmirror for some time now to achieve it. While 
attending Jan's workshop on Slony I came to the conclusion that it would 
be difficult to contort it to serve such a purpose -- but very useful 
for several other purposes ;-)

Joe