Steve Singer ssinger at ca.afilias.info
Fri Aug 6 12:54:12 PDT 2010
Fharid Salomon Fernandez wrote:
> Hello, i'm new using this slony-I replication system, and i have little doubts about defining the replications sets.
> In the slony-i documentation it says that i have to group those tables that are related via foreign key constraints in one set, so the objetive
> here is to have varoius sets from one database, the problem is that , i have a large database  where all the tables are related, for example
> i have some tables for the human resources module, those tables are related (employees, location, etc) and some of those tables are related to
> tables from other modules (sales, accounts, etc), so it means that i can't separate the tables in diferent sets because some of them act like bridges
> relating all the tables from the database, and I have to define one big set with all the tables??? ....
> please what can i do in order to have the correct number of replication sets from my database.
>  		 	


There isn't anything wrong with having all off your tables in one 
replication set.  In fact, that is a very common way of deploying slony.

    		
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142


More information about the Slony1-general mailing list