On 12-03-15 09:52 PM, Brian Trudal wrote:
> Looks like a odd situation;
>
> I have 2 sets, and one set with 3 tables and another with 50+ tables.
> Both the sets are replicated to two subscribers; one set has correct
> data, but second set two tables are off.

How did you get your cluster into this situation?  Something has gone wrong.

I assume your still using 2.0.7 with PG 8.4

>
> And both the subscribers are up2date with origin; but 2 tables out of 3,
> has wrong number of rows (way off) in subscriber-1;
>
> So, whats the best way to re-copy or re-initiate these two tables copy
> only to subsriber-1 without subsriber-2 (it shares the set) as
> subscriber-2 is prod read facing.

You can unsubscribe subscriber 1 from the set with the UNSUBSCRIBE SET 
command.  You can then resubscribe subscriber 1 with the
SUBSCRIBE SET command.  This should not effect subscriber 2.



>
> Thanks for the help
> Brian
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general