Tue Feb 5 08:49:52 PST 2008
- Previous message: [Slony1-general] partial replication
- Next message: [Slony1-general] partial replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jean-Christophe Praud a écrit : > Hi all, > > I'm new to Slony, here's my newbie question : > > I need to setup a cluster of separate servers, each handling a set of > users data. > The architecture I'm planning is : > > - 1 central server storing my whole users table (id, login, passwd, > id_of_users_server) > - n users servers containing the part of the central users table > - a user authenticate on the central server, then the application uses > the users server hosting this user > > As each users server will contain a part of the central users table, > modifications of each record of this table on the central server need to > be replicated to the good users server. > > > I don't plan to use inherited partitions for the central users table (I > need PK, FK and other constraints on this table). Can Slony be used to > do the partial replication from central to each users server ? > > Hi, Not sure I understand everything, but if the question is "can slony replicate portions of table based on values", the answer is "no". Regards, -- Stéphane SCHILDKNECHT Président de PostgreSQLFr Tél. 09 53 69 97 12 http://www.postgresqlfr.org
- Previous message: [Slony1-general] partial replication
- Next message: [Slony1-general] partial replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list