On 12-02-28 10:42 PM, 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

This is not possible.

You can have

DB1:
public.a
public.b

DB2:
public.a

where some tables on db1 don't exist in db2 but any of the tables that 
are being replicated must have the same fully qualified name on both 
systems.



>
> 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’);