On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin@xxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
