From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Armin Resch <armin(at)reschab(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Replication by schema |
Date: | 2011-02-16 20:35:03 |
Message-ID: | AANLkTi=uwCkqy+fh8_Op-LCA_WLpq+DUp-=fO_WQFfAC@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin(at)reschab(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-02-16 20:45:40 | Re: Postgres on NAS/NFS |
Previous Message | Scott Marlowe | 2011-02-16 20:33:18 | Re: Replication by schema |