On Tue, Feb 28, 2012 at 07:42:56PM -0800, NewToSlony wrote: > Is it possible to replicate tables from one database to another if they have > different schemas? For example > > Working set is: > DB1 > Schema1 > > DB2 > Schema2 > > Want to replicate a subset of tables from DB1 -> DB2. The tables have the > exact same composition, but as DB2 does not have have the entire set of > tables from DB1, the schema is different.
That works, _as long as_ the tables themselves have the same schema. That is, Slony works on sets of tables. Those sets are not identical to the database schema, but the table definition must match on all nodes in the set. A -- Andrew Sullivan [email protected] _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
