Part I. Core
Slony-I
Programs
Table of Contents
slon
- Slony-I daemon
Run-time Configuration
1. Logging
2. Connection settings
3. Event Tuning
slonik
- Slony-I command processor
Slonik Command Summary
1. Introduction
1.1. General outline
I. Slonik Meta Commands
INCLUDE
- pulling in slonik code from another file
DEFINE
- Defining a named symbol
II. Slonik Preamble Commands
CLUSTER NAME
- preamble - identifying Slony-I cluster
ADMIN CONNINFO
- preamble - identifying PostgreSQL database
III. Configuration and Action commmands
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