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 ?


-- 
Jean-Christophe Praud         -      http://shub-niggurath.com
Conseil & Développement Informatique      http://www.praud.com
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!