GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SLONIK_DROP_SET (7)

NAME

DROP SET - Discard Slony-I replication set

CONTENTS

Synopsis

SYNOPSIS

DROP SET (options);

DESCRIPTION

Drop a set of tables from the Slony-I configuration. This automatically unsubscribes all nodes from the set and restores the original triggers and rules on all subscribers.
ID = ival
  ID of the set to be dropped.
ORIGIN = ival
  Current origin node of the set.
This uses dropset(integer).

EXAMPLE

  DROP SET ( ID = 5,
             ORIGIN = 2 );
   

LOCKING BEHAVIOUR

On each node, this will require taking out exclusive locks on each replicated table in order to modify the table schema to clean up the triggers and rules.

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.

VERSION INFORMATION

This command was introduced in Slony-I 1.0

Search for    or go to Top of page |  Section 7 |  Main Index


SLONIK DROP SET (7) 18 January 2015

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.