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
> [email protected]
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
