Christopher Browne cbbrowne at ca.afilias.info
Fri Aug 7 15:18:16 PDT 2009
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"


More information about the Slony1-general mailing list