On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > 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. OK, it can't change schemas, but if you named them something unique in both places it will work. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
