Josh Harrison joshques at gmail.com
Wed Dec 19 18:37:24 PST 2007
Hi
I have a couple of questions regarding applying  schema changes in slony
The manual says
"When you run EXECUTE
SCRIPT<http://slony.info/adminguide/slony1-1.2.6/doc/adminguide/stmtddlscri=
pt.html>,
this causes the
slonik<http://slony.info/adminguide/slony1-1.2.6/doc/adminguide/slonik.html=
>to
request,
*for each table in the specified set*, an exclusive table lock"
So all the tables in the master and slave are locked for that time? So the
applications accessing that specified set of tables will receive some error
or something atthat particular time? How long is this time generally?
In the production environment is this okay? Anyone had tried this? Are there
any other problems that you had encountered using execute script in the
production env?  Is there any other alternatives?

Thanks
josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071219/=
4c3b757a/attachment-0001.htm


More information about the Slony1-general mailing list