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