Andrew Sullivan a ?crit :

>On Fri, Nov 05, 2004 at 11:19:24AM +0100, "Dr. St?phane Schildknecht" wrote:
>  
>
>>Hi all,
>>
>>We have a soft that creates table whenever a new user connects to it. Is 
>>it possible to automate the creation of the tables on the slaves ?
>>    
>>
>
>Sort of, but if the idea is _regularly_ to do this sort of table
>creation, you're going to find Slony hard to use.  If you're really
>wedded to such a design (and I have to say that I think it's probably
>poor practice), you maybe want to check out the Command Prompt
>system, instead, since it's based on shipping logs.
>
>Anyway, check out the DDL support in slonik. But you _must_ submit
>such changes that way for the system to work in the ways you expect.
>
>A
>
>  
>
I won't enter the discussion to decide whether or not it's a good 
practice (I have an idee, not far from yours ;-), but this soft 
(OpenGroupWare.org) has been chosen for that project, and it 
unfortunately creates a table for every new user to the groupware.
I HAVE TO replicate the database. But, commandprompt, as a commercial 
product hasn't been chosen. Having tried it, I know it could have been a 
solution (despite some strange behaviour when master crashes...), but ...

Let's see what I can do with Slony...

S at S

-- 
St?phane SCHILDKNECHT

LINAGORA
30 rue Saint Augustin 75002 PARIS
Tel : +33(0)1 58 18 68 28
fax : +33(0)1 58 18 68 29
http://www.linagora.com