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 <ABhat at trustwave.com> 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
jason at buberel.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081104/=
b69e729a/attachment.htm