On Sat, Jan 07, 2006 at 02:20:53PM +0000, John Sidney-Woollett wrote:
> I need to add a single sequence to an existing replicated set (slony
> 1.1.0 and Postgres 7.4.6)
>
> I remember that it is not advised to have a set with a single sequence
> (although I can't remember why).
Because it won't work. It's some sort of breakage. I don't recall
whether it's been fixed -- IIRC it should be fixable, but I suspect
nobody has cared enough to do it.
> 1) Create temp set. Add sequence to it. Subscribe all slaves to it.
> Merge with existing set.
This will work, except that you should create a dummy table as well.
Then merge the sets, and then use SET DROP TABLE to drop the dummy
table. It's a kludgey workaround, but it does work around without
having to rebuild the whole replica from nothing.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
