On Tuesday October 19 2004 11:06, Darcy Buskermolen wrote:
>
> Have a look for the execute script command in slonik

Sweet!

% cat replicate_ddl.sh 
slonik <<_EOF_
    cluster name = $CLUSTERNAME;
    node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST 
port=$MASTERPORT user=$MASTERDBA';
    execute script ( set id=1, FILENAME = './schemachange.sql', EVENT NODE = 
1 );
_EOF_

% cat schemachange.sql 
alter table branches add column bar integer;

Not the first time I've requested a feature that already existed!  I'd say 
this definitely deserves more prominent documentation, as this is a big 
win.  Are there any concerns about this functionality?  Any known gotchas?

Ed