Fri Aug 7 15:18:16 PDT 2009
- Previous message: [Slony1-general] Alter table commands not replicating
- Next message: [Slony1-general] Set Add Sequence Error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Sweta Mulgavker <sweta.mulgavker at gmail.com> 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@~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"
- Previous message: [Slony1-general] Alter table commands not replicating
- Next message: [Slony1-general] Set Add Sequence Error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list