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.  

I ask as I look through the documentation I'm confused how to accomplish
this.  As I look at the tutorial I see where via the 'SET ADD' command you
tell Slony to use teh tables from pgbench.  public is the schema but if I
were to do this with the above example, is it Schema1, Schema2 or is this
not possible?


create set (id=1, origin=1, comment=’All pgbench tables’); 
set add table (set id=1, origin=1, id=1, fully qualified name =
’public.pgbench_accounts ←ﰇ
’, comment=’accounts table’); 
set add table (set id=1, origin=1, id=2, fully qualified name =
’public.pgbench_branches ←ﰇ
’, comment=’branches table’);
-- 
View this message in context: http://old.nabble.com/Can-you-replicate-tables-between-two-db%27s-with-different-schemas--tp33411498p33411498.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.