On Thu, Jan 04, 2007 at 05:16:10PM -0500, Andrew Sullivan wrote:
> Not just dropping them, but the following appears to work:
Oops, not quite.
> Call it _n_. Then you do this:
>
> 1. On the origin, do
>
> SELECT _slonyschema.altertablerestore(_n_);
>
> 2. Wait. Make sure the events propogate everywhere.
>
> 5. On the origin, do
>
> SELECT _slonyschema.altertableforreplication(_n_);
You actually don't need step 2, but you _do_ need to do steps 1 and 5
on every node. Now that I think about it, I knew that, but forgot.
Anyway, I think I'll write up a little script that will do this
generically, on the presumption that others might need it.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
