On Wed, 2008-12-10 at 13:54 +0100, "Stéphane A. Schildknecht" wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hi,
> 
> I tried to add a set with some tables and sequences to an already existing
> replication.
> 
> Trouble is I messed up numbering my sequences, and then I obtained some error :
> ...

> On the two desynchronized sets, set 3 still exists, but sl_table and
> sl_sequence don't know about objects in the set.
> 
> For information, I'm on PG8.2.11, with Slony 1.2.15.
> Replication goes this way : 1->11->71->72. 71 and 72 can't synchronize anymore.
> 
> On node 71/72, the set still exists in sl_set and sl_subscribe. Is there a way
> I could purge nodes from any reference to that set ?

The only sure way is to just go through all nodes and manually clean up
all sl_* tables referencing your new set (and possibly also all
references to tables and sequences in these sets)

but before that, you should unsubscribe the tables and sequences in
those sets from all subscribers, preferrably using slony's unsubscribe
functions on each of them so that the don't end up in a broken state,
with constraints hidden in an unclean way etc.

better make a script to do it and then run it on all nodes. stop all
slony daemons whily you are at it, so they don't interfere.

> Thanks by advance.
> 
> - --
> Stéphane Schildknecht
> PostgreSQLFr - http://www.postgresql.fr
> Dalibo - http://www.dalibo.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFJP7wLA+REPKWGI0ERAiKbAKDDJb+oLTBi0787aRuBE7e7EN4W3ACeO9q+
> +vGQQ8ndG6cA7tcJS7zdbRQ=
> =SRZu
> -----END PGP SIGNATURE-----
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
-- 
------------------------------------------
Hannu Krosing   http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability 
   Services, Consulting and Training