Configuration and Action commmands


Table of Contents

ECHO — Generic output tool
EXIT — Terminate Slonik script with signal
INIT CLUSTER — Initialize Slony-I cluster
STORE NODE — Initialize Slony-I node
DROP NODE — Remove the node from participating in the replication
UNINSTALL NODE — Decommission Slony-I node
RESTART NODE — Restart Slony-I node
STORE PATH — Configure Slony-I node connection
DROP PATH — Delete Slony-I connection information
STORE LISTEN — Configure Slony-I node to indicate where to listen for events
DROP LISTEN — Eliminate configuration indicating how Slony-I node listens for events
TABLE ADD KEY — Add primary key for use by Slony-I for a table with no suitable key
CREATE SET — Create Slony-I replication set
DROP SET — Discard Slony-I replication set
MERGE SET — Merge Slony-I replication sets together
SET ADD TABLE — Add a table to a Slony-I replication set
SET ADD SEQUENCE — Add a sequence to a Slony-I replication set
SET DROP TABLE — Remove a table from a Slony-I replication set
SET DROP SEQUENCE — Remove a sequence from a Slony-I replication set
SET MOVE TABLE — Move a table from one Slony-I replication set to another
SET MOVE SEQUENCE — Move a sequence from one Slony-I replication set to another
STORE TRIGGER — Indicate that a trigger should not be disabled by Slony-I on a subscriber node
DROP TRIGGER — Return a trigger to default behavior, where it will not fire on subscriber nodes
SUBSCRIBE SET — Start replication of Slony-I set
UNSUBSCRIBE SET — End replication of Slony-I set
LOCK SET — Guard Slony-I replication set to prepare for MOVE SET
UNLOCK SET — Unlock a Slony-I set that was locked
MOVE SET — Change origin of a Slony-I replication set
FAILOVER — Fail a broken replication set over to a backup node
EXECUTE SCRIPT — Execute SQL/DDL script
UPDATE FUNCTIONS — Reload stored functions
WAIT FOR EVENT — Have Slonik script wait for previous event to complete
REPAIR CONFIG — Resets the name-to-oid mapping of tables in a replication set, useful for restoring a node after a pg_dump.
SYNC — Generate an ordinary SYNC event
SLEEP — Sleep using system sleep()