Slony-I
1.2.7 Documentation
Prev
Fast Backward
Fast Forward
Next
I. Core
Slony-I
Programs
Table of Contents
slon
--
Slony-I
daemon
1.
Logging
2.
Connection settings
3.
Archive Logging Options
4.
Event Tuning
slonik
--
Slony-I
command processor
1.
Introduction
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()
Prev
Home
Next
slon