Re: Replication by schema

On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin@reschab.net> wrote:
>> Hi there,
>>
>> what options do exist to replicate from a master by schema?
>>
>> What I'm really after is this scenario:
>>
>> Say, I have 100 databases out in the field. All of them have the same schema
>> and are autonomous masters. Now, at a central location, I want to replicate
>> from all masters to a central slave (which would have the combined data
>> footprint from all masters). Now, if schema-based replication was possible,
>> I would configure the slave to replicate the first master's schema 'A' to
>> the central slave's schema 'Master01', the second master's schema 'A' to the
>> central slave's schema 'Master02', etc.
>>
>> Making sense? Is there appetite by anyone else for something like that?
>> Would there be insurmountable architectural hurdles to make this a built-in
>> replication option?
>
> Slony can already do all of this.

OK, it can't change schemas, but if you named them something unique in
both places it will work.