One more quick/easy question:

Given that I have one table that would appear in several sets (named 
'public.city_summary'), that will be replicated as follows:

srv2:stats_db (node 2) ->
    srv1:production_db (node 1) -> 
        srv3:production_backup (node 3)

Should that table be given the same id# in all three sets:

create set (id=1, origin=2, comment='stats set');
...
set add table (id=1, set id=1, origin=2, 
    fully qualified name='public.city_summary');
...

create set (id=2, origin=1, comment='production backup');
...
set add table (id=1, set id=2, origin=2,
    fully qualified name='public.city_summary');

Or would each table definition in each set need globally unique identifier?

Thanks,
jason


Andrew Sullivan writes:

> On Tue, May 15, 2007 at 04:20:54PM -0500, jason at buberel.org wrote:
>> Consider the following configuration:
>> 
>> Cluster #1: prod_backup_cluster: Used to replicate all tables and all data 
> 
>> Cluster #2: prod_trxn_cluster: Used to replicate certain customer 
> 
> You can't have more than one "cluster" in slony that covers the same
> tables.  You can have more than one set, not all of which are
> subscribed to by all nodes.  I think this answers your questions, but
> if not, please ask more.
> 
> A
> 
> -- 
> Andrew Sullivan  | ajs at crankycanuck.ca
> I remember when computers were frustrating because they *did* exactly what 
> you told them to.  That actually seems sort of quaint now.
> 		--J.D. Baldwin
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general