Dun dun
Thu Jan 11 22:58:12 PST 2007
Steve Singer wrote:
> What we have found much more painful is adding columns (or any other 
> ALTER table) command to tables that are already being replicated.  In 
> the current version of slony this requires obtain an exclusive lock on 
> all replicated tables in all sets.  This essentially requires an 
> outage/maintaince window to avoid deadlock.

I thought that for execute script slonik requires an exclusive lock on 
all replicated tables /in the same set/. 
(http://linuxfinances.info/info/ddlchanges.html)

Regards

MP




More information about the Slony1-general mailing list