Hi Sweta, You should run your changes through slonik
http://www.slony.info/documentation/stmtddlscript.html Glyn > >From: Sweta Mulgavker <[email protected]> >To: slony1-general <[email protected]> >Sent: Friday, 7 August, 2009 10:22:24 >Subject: [Slony1-general] Alter table commands not replicating > >Hello all, > >In my slony setup... I am replicating one master slave pair. >Data is replicating fine... but if I try to alter one table while slony is >running the updated table is not replicated in slave db.... > >>My question is ... > >If while running slony we alter any table structure in the master db then do >these changes get replicated on the slave too? I was trying to add new cloumn >to one of the table. > >Or do we have to take a manual dump and restore the schema again on slave? > >Regards, >Sweta >
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
