On Thursday 30 November 2006 02:44, Bernd Helmle wrote: > You need to define two separate clusters which could > then replicate their master nodes to the same database > on your slave (so node 3 is becoming a slave within > both clusters), > > but you cannot have two masters within one slony cluster.
I think that answers my question. I don't have two masters, but I did notice slony lets you define different providers for sets. So I set up node 1 to provide one schema, and node 2 to provide another, both to node 3. Basically I did this: cluster name = replication; ... init cluster (id = 1, comment = 'Node 1'); store node (id = 2, event node = 1, comment = 'Node 2'); store node (id = 100, event node = 1, comment = 'Node 100'); create set (id = 1, origin = 1, comment = 'Set 1'); ... # tables in schema 1 create set (id = 2, origin = 2, comment = 'Set 2'); ... # tables in schema 2 subscribe set (id = 1, provider = 1, receiver = 100, forward = yes); subscribe set (id = 2, provider = 2, receiver = 100, forward = yes); And you're saying I should probably set up two separate clusters for node 1 and 2 instead. I can do that, I just had to know for sure; it was behaving if that was the case, but it's hard to tell. -- Shaun Thomas Database Administrator Leapfrog Online 807 Greenwood Street Evanston, IL 60201 Tel. 847-440-8253 Fax. 847-570-5750 www.leapfrogonline.com _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
