On Fri, 22 Aug 2014, Venkata Balaji N wrote:

> Hello Everyone,
> We have a situation where  Slony schema on a slave node was accidentally dropped.
> 
> Is there any quick way around for this ?
> 
> We have a master replicating to 3 slaves and one of the slaves does not have the Slony schema.
> 
> - Can we just un-subscribe that slave and resubscribe back to catch up with the sync ?
> 
> In anyone faced such situation, please help us with this.

You should issue a DROP NODE command for the slave that lost the schema 
(using another node as the event node).

You can then create the node again as a new node and resubscribe.

> 
> Regards,
> VBN
> 
>