| Slony-I 1.2.13 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
I. Core Slony-I Programs
- Table of Contents
- slon -- Slony-I daemon
- slonik -- Slony-I command processor
- 1. Introduction
- I. Slonik Meta Commands
- 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()