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
ajs at crankycanuck.ca