cbbrowne at ca.afilias.info cbbrowne at ca.afilias.info
Fri Dec 21 15:42:22 PST 2007
> Hi Praveen,
>
>>From looking over the steps below it seems this will drop my whole
> cluster will it not?
>
> I only want to drop one of the replication sets within my cluster.
>
> I.e.
>
> I have a slony I cluster called "replication1", and within this I
> have 3 replication sets, "customers", "events" and "eventData".
>
> I just want to drop the "eventData" replication set from the cluster.

There's something funny there...

Replication sets are numbered, not named.

I'd instead expect that you have three sets:

Set 1, with some tables for customers,
Set 4, with some tables for events,
Set 9, with EventData tables.

(Or it could be sets 1, 2, and 3; I don't want to assume either way.)

You could drop set #9 via the slonik command

DROP SET (ID = 9, EVENT NODE = [preferably the origin for set #9]);

(The script also needs to include the "preamble" stuff required in every
Slonik script...)



More information about the Slony1-general mailing list