'\" -*- coding: us-ascii -*-
.if \n(.g .ds T< \\FC
.if \n(.g .ds T> \\F[\n[.fam]]
.de URL
\\$2 \(la\\$1\(ra\\$3
..
.if \n(.g .mso www.tmac
.TH "SLONIK UNSUBSCRIBE SET" 7 "24 July 2014" "" "Slony-I 2.2.3 Documentation"
.SH NAME
UNSUBSCRIBE SET \- End replication of Slony-I set 
.SH SYNOPSIS
'nh
.fi
.ad l
\fBUNSUBSCRIBE SET (options);\fR \kx
.if (\nx>(\n(.l/2)) .nr x (\n(.l/5)
'in \n(.iu+\nxu
'in \n(.iu-\nxu
.ad b
'hy
.SH DESCRIPTION
Stops the subscriber from replicating the set. The tables
are opened up for full access by the client application on the
former subscriber. The tables are not truncated or otherwise
modified. All original triggers, rules and constraints are
restored.
.TP 
\*(T<ID = ival \*(T>
ID of the set to unsubscribe
.TP 
\*(T<RECEIVER = ival \*(T>
Node ID of the (former) subscriber
.SH EXAMPLE
.nf
\*(T<UNSUBSCRIBE SET (
   ID = 1,
   RECEIVER = 3
);
    \*(T>
.fi
.SH "LOCKING BEHAVIOUR "
Exclusive locks on each replicated table will be taken out
on the subscriber in order to drop replication triggers from the
tables and restore other triggers/rules. 
.SH "SLONIK EVENT CONFIRMATION BEHAVIOUR "
Slonik waits for the command submitted to the previous
event node to be confirmed on the specified event node before
submitting this command.
.SH "DANGEROUS/UNINTUITIVE BEHAVIOUR "
Resubscribing an unsubscribed set requires a
\fIcomplete fresh copy\fR of data from the
provider to be transferred since the tables have been subject to
possible independent modifications. 
.SH "VERSION INFORMATION "
This command was introduced in Slony-I 1.0