Although probably not the recommended process, here is what I've been doing for a few years now that I've been using Slony in production:
1. Stop all slon daemons on the cluster. 2. Run the SQL patch script that adds the column to the replicated table. Run it on each node in the cluster. 3. Start slon daemon on master. Wait a minute. Check logs for errors and such. 4. Start remaining slon daemons for remaining cluster nodes. Watch log files vigilantly for one hour. 5. Drink beer. -jason On Tue, Nov 4, 2008 at 2:55 PM, Anoop Bhat <[EMAIL PROTECTED]> wrote: > What is the recommended way of adding fields to a replicated table when > using altperl scripts? > > Anoop Bhat > Systems Administrator > Trustwave > 70 W. Madison > Chicago, IL, 60602 > O: 312.873.7446 > C: 312.925.3271 > -- Jason L. Buberel [EMAIL PROTECTED]
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
