Part I. Core
Slony-I
Programs
Table of Contents
slon
—
Slony-I
daemon
Run-time Configuration
1. Logging
2. Connection settings
3. Archive Logging Options
4. 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
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()