Slony-I
1.1.5 Documentation
The PostgreSQL Global Development Group
Christopher Browne
Copyright
© 2004-2006 The PostgreSQL Global Development Group
Table of Contents
1.
Introduction to
Slony-I
2.
Slony-I
Communications Costs
3.
System Requirements
4.
Slony-I
Installation
5.
Slony-I
Concepts
6.
Defining
Slony-I
Clusters
7.
Defining
Slony-I
Replication Sets
1.
Replicating Your First Database
2.
Slon daemons
3.
Subscribing Nodes
4.
Monitoring
5.
Slony-I
Maintenance
6.
Reshaping a Cluster
7.
Doing switchover and failover with
Slony-I
8.
Slony-I
listen paths
9.
Slony-I
Path Communications
10.
Locking Issues
11.
Adding Things to Replication
12.
Dropping things from
Slony-I
Replication
13.
Log Shipping -
Slony-I
with Files
14.
Database Schema Changes (DDL)
15.
Using Slonik
16.
Embedding Slonik in Shell Scripts
17.
Not Using Slonik - Bare Metal
Slony-I
Functions
18.
Slony-I
Administration Scripts
19.
Using
Slony-I
for
PostgreSQL
Upgrades
20.
Slony-I
"Best Practices"
21.
Slony-I
Test Bed Framework
22.
More
Slony-I
Help
I.
Core
Slony-I
Programs
slon
--
Slony-I
daemon
slonik
--
Slony-I
command processor
I.
Slonik Meta Commands
II.
Slonik Preamble Commands
III.
Configuration and Action commmands
1.
Schema schemadoc
1.1.
Table:
sl_config_lock
1.2.
Table:
sl_confirm
1.3.
Table:
sl_event
1.4.
Table:
sl_listen
1.5.
Table:
sl_log_1
1.6.
Table:
sl_log_2
1.7.
Table:
sl_node
1.8.
Table:
sl_path
1.9.
View:
sl_seqlastvalue
1.10.
Table:
sl_seqlog
1.11.
Table:
sl_sequence
1.12.
Table:
sl_set
1.13.
Table:
sl_setsync
1.14.
Table:
sl_subscribe
1.15.
Table:
sl_table
1.16.
Table:
sl_trigger
1.17.
add_missing_table_field( text, text, text, text )
1.18.
altertableforreplication( integer )
1.19.
altertablerestore( integer )
1.20.
cleanupevent( )
1.21.
cleanuplistener( )
1.22.
createevent( name, text )
1.23.
createevent( name, text, text )
1.24.
createevent( name, text, text, text )
1.25.
createevent( name, text, text, text, text )
1.26.
createevent( name, text, text, text, text, text )
1.27.
createevent( name, text, text, text, text, text, text )
1.28.
createevent( name, text, text, text, text, text, text, text )
1.29.
createevent( name, text, text, text, text, text, text, text, text )
1.30.
createevent( name, text, text, text, text, text, text, text, text, text )
1.31.
ddlscript( integer, text, integer )
1.32.
ddlscript_int( integer, text, integer )
1.33.
denyaccess( )
1.34.
determineattkindserial( text )
1.35.
determineattkindunique( text, name )
1.36.
determineidxnameserial( text )
1.37.
determineidxnameunique( text, name )
1.38.
disablenode( integer )
1.39.
disablenode_int( integer )
1.40.
droplisten( integer, integer, integer )
1.41.
droplisten_int( integer, integer, integer )
1.42.
dropnode( integer )
1.43.
dropnode_int( integer )
1.44.
droppath( integer, integer )
1.45.
droppath_int( integer, integer )
1.46.
dropset( integer )
1.47.
dropset_int( integer )
1.48.
droptrigger( integer, name )
1.49.
droptrigger_int( integer, name )
1.50.
enablenode( integer )
1.51.
enablenode_int( integer )
1.52.
enablesubscription( integer, integer, integer )
1.53.
enablesubscription_int( integer, integer, integer )
1.54.
failednode( integer, integer )
1.55.
failednode2( integer, integer, integer, bigint, bigint )
1.56.
failoverset_int( integer, integer, integer )
1.57.
forwardconfirm( integer, integer, bigint, timestamp without time zone )
1.58.
generate_sync_event( interval )
1.59.
getlocalnodeid( name )
1.60.
getmoduleversion( )
1.61.
getsessionrole( name )
1.62.
initializelocalnode( integer, text )
1.63.
lockedset( )
1.64.
lockset( integer )
1.65.
logtrigger( )
1.66.
mergeset( integer, integer )
1.67.
mergeset_int( integer, integer )
1.68.
moveset( integer, integer )
1.69.
moveset_int( integer, integer, integer )
1.70.
rebuildlistenentries( )
1.71.
rebuildlistenentriesone( integer, integer )
1.72.
sequencelastvalue( text )
1.73.
sequencesetvalue( integer, integer, bigint, bigint )
1.74.
setaddsequence( integer, integer, text, text )
1.75.
setaddsequence_int( integer, integer, text, text )
1.76.
setaddtable( integer, integer, text, name, text )
1.77.
setaddtable_int( integer, integer, text, name, text )
1.78.
setdropsequence( integer )
1.79.
setdropsequence_int( integer )
1.80.
setdroptable( integer )
1.81.
setdroptable_int( integer )
1.82.
setmovesequence( integer, integer )
1.83.
setmovesequence_int( integer, integer )
1.84.
setmovetable( integer, integer )
1.85.
setmovetable_int( integer, integer )
1.86.
setsessionrole( name, text )
1.87.
slon_quote_brute( text )
1.88.
slon_quote_input( text )
1.89.
slonyversion( )
1.90.
slonyversionmajor( )
1.91.
slonyversionminor( )
1.92.
slonyversionpatchlevel( )
1.93.
storelisten( integer, integer, integer )
1.94.
storelisten_int( integer, integer, integer )
1.95.
storenode( integer, text, boolean )
1.96.
storenode_int( integer, text, boolean )
1.97.
storepath( integer, integer, text, integer )
1.98.
storepath_int( integer, integer, text, integer )
1.99.
storeset( integer, text )
1.100.
storeset_int( integer, integer, text )
1.101.
storetrigger( integer, name )
1.102.
storetrigger_int( integer, name )
1.103.
subscribeset( integer, integer, integer, boolean )
1.104.
subscribeset_int( integer, integer, integer, boolean )
1.105.
tableaddkey( text )
1.106.
tabledropkey( integer )
1.107.
tablehasserialkey( text )
1.108.
terminatenodeconnections( name )
1.109.
uninstallnode( )
1.110.
unlockset( integer )
1.111.
unsubscribeset( integer, integer )
1.112.
unsubscribeset_int( integer, integer )
1.113.
updaterelname( integer, integer )
1.114.
updatereloid( integer, integer )
1.115.
upgradeschema( text )
Index
List of Tables
1.
Supported Platforms
List of Figures
1-1.
Definition of view sl_seqlastvalue
Next