Wed Dec 19 18:37:24 PST 2007
- Previous message: [Slony1-general] questions about slon_tools.conf
- Next message: [Slony1-general] Applying schema changes in slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] questions about slon_tools.conf
- Next message: [Slony1-general] Applying schema changes in slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list