In the docs, a suggested method to upgrade 2.1 to to 2.2 is as follows:
1. Use SLONIK LOCK SET to lock all sets, so that no new changes are being injected into the log tables 2. Set slon parameter slon_config_cleanup_interval to a very low value (a few seconds) so that the slon cleanup thread will trim data out of sl_log_1 and sl_log_2 immediately 3. Restart slon for each node and let it run through a cleanup cycle to empty out sl_log_1 and sl_log_2 on all nodes. 4. Verify that sl_log_1 and sl_log_2 are empty on all nodes in the cluster. 5. Use SLONIK UPDATE FUNCTIONS against each node to upgrade to version 2.2 6. Use SLONIK UNLOCK SET to unlock all sets Based on my experience and other reading, I think between steps 4 and 5 should be: 1. stop slon 2. install new version of slony then after step 5, restart slon. Is that the correct place to perform the install? Or can/should that be done between steps 2 and 3? Also, will the lock set survive restarting slon? I thought it took out an exclusive lock on all tables, but if you stop the process, the locks would then go away.
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
