Sweta Mulgavker <[email protected]> writes: > 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?
DDL is not automatically propagated; it must be managed quite carefully. There is a whole section in the documentation on use of "EXECUTE SCRIPT". http://main.slony.info/documentation/ddlchanges.html -- (format nil "~...@~s" "cbbrowne" "ca.afilias.info") <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
