Slony-I
2.0.6 Documentation
The PostgreSQL Global Development Group
Christopher Browne
Copyright
© 2004-2010 The PostgreSQL Global Development Group
Table of Contents
1.
Preface
1.1.
Introduction to
Slony-I
1.2.
System Requirements
1.3.
Slony-I
Concepts
1.4.
Current Limitations
2.
Tutorial
2.1.
Replicating Your First Database
2.2.
Starting & Stopping Replication
3.
Administration Tasks
3.1.
Modifying Replication Clusters
3.2.
Database Schema Changes (DDL)
3.3.
Doing switchover and failover with
Slony-I
4.
Advanced Topics
4.1.
Events & Confirmations
4.2.
Slony-I
Listen Paths
4.3.
Monitoring
4.4.
Log Shipping -
Slony-I
with Files
4.5.
Partitioning Support
4.6.
Slony-I
Upgrade
4.7.
Log Analysis
4.8.
Performance Considerations
4.9.
Slony-I
Trigger Handling
4.10.
Locking Issues
4.11.
Security Considerations
5.
Appendix
5.1.
Slony-I
Administration Scripts
5.2.
Frequently Asked Questions
5.3.
Slony-I
Supported Platforms
5.4.
Release Checklist
5.5.
More
Slony-I
Help
I.
Reference
slon
--
Slony-I
daemon
slonik
--
Slony-I
command processor
I.
Slonik Meta Commands
II.
Slonik Preamble Commands
III.
Configuration and Action commmands
6.
Schema schemadoc
6.1.
Table:
sl_archive_counter
6.2.
Table:
sl_config_lock
6.3.
Table:
sl_confirm
6.4.
Table:
sl_event
6.5.
Table:
sl_listen
6.6.
Table:
sl_log_1
6.7.
Table:
sl_log_2
6.8.
Table:
sl_node
6.9.
Table:
sl_nodelock
6.10.
Table:
sl_path
6.11.
Table:
sl_registry
6.12.
View:
sl_seqlastvalue
6.13.
Table:
sl_seqlog
6.14.
Table:
sl_sequence
6.15.
Table:
sl_set
6.16.
Table:
sl_setsync
6.17.
Table:
sl_subscribe
6.18.
Table:
sl_table
6.19.
add_empty_table_to_replication(integer, integer, text, text, text, text)
6.20.
add_missing_table_field(text, text, text, text)
6.21.
addpartiallogindices()
6.22.
altertableaddtriggers(integer)
6.23.
altertableconfiguretriggers(integer)
6.24.
altertabledroptriggers(integer)
6.25.
checkmoduleversion()
6.26.
cleanupevent(interval, boolean)
6.27.
cleanupnodelock()
6.28.
clonenodefinish(integer, integer)
6.29.
clonenodeprepare(integer, integer, text)
6.30.
clonenodeprepare_int(integer, integer, text)
6.31.
copyfields(integer)
6.32.
createevent(name, text)
6.33.
createevent(name, text, text)
6.34.
createevent(name, text, text, text)
6.35.
createevent(name, text, text, text, text)
6.36.
createevent(name, text, text, text, text, text)
6.37.
createevent(name, text, text, text, text, text, text)
6.38.
createevent(name, text, text, text, text, text, text, text)
6.39.
createevent(name, text, text, text, text, text, text, text, text)
6.40.
createevent(name, text, text, text, text, text, text, text, text, text)
6.41.
ddlscript_complete(integer, text, integer)
6.42.
ddlscript_complete_int(integer, integer)
6.43.
ddlscript_prepare(integer, integer)
6.44.
ddlscript_prepare_int(integer, integer)
6.45.
denyaccess()
6.46.
determineattkindunique(text, name)
6.47.
determineidxnameunique(text, name)
6.48.
disablenode(integer)
6.49.
disablenode_int(integer)
6.50.
droplisten(integer, integer, integer)
6.51.
droplisten_int(integer, integer, integer)
6.52.
dropnode(integer)
6.53.
dropnode_int(integer)
6.54.
droppath(integer, integer)
6.55.
droppath_int(integer, integer)
6.56.
dropset(integer)
6.57.
dropset_int(integer)
6.58.
enablenode(integer)
6.59.
enablenode_int(integer)
6.60.
enablesubscription(integer, integer, integer)
6.61.
enablesubscription_int(integer, integer, integer)
6.62.
failednode(integer, integer)
6.63.
failednode2(integer, integer, integer, bigint, bigint)
6.64.
failoverset_int(integer, integer, integer, bigint)
6.65.
finishtableaftercopy(integer)
6.66.
forwardconfirm(integer, integer, bigint, timestamp without time zone)
6.67.
generate_sync_event(interval)
6.68.
getlocalnodeid(name)
6.69.
getmoduleversion()
6.70.
initializelocalnode(integer, text)
6.71.
killbackend(integer, text)
6.72.
lockedset()
6.73.
lockset(integer)
6.74.
logswitch_finish()
6.75.
logswitch_start()
6.76.
logtrigger()
6.77.
mergeset(integer, integer)
6.78.
mergeset_int(integer, integer)
6.79.
moveset(integer, integer)
6.80.
moveset_int(integer, integer, integer, bigint)
6.81.
preparetableforcopy(integer)
6.82.
rebuildlistenentries()
6.83.
registernodeconnection(integer)
6.84.
registry_get_int4(text, integer)
6.85.
registry_get_text(text, text)
6.86.
registry_get_timestamp(text, timestamp without time zone)
6.87.
registry_set_int4(text, integer)
6.88.
registry_set_text(text, text)
6.89.
registry_set_timestamp(text, timestamp without time zone)
6.90.
replicate_partition(integer, text, text, text, text)
6.91.
reshapesubscription(integer, integer, integer)
6.92.
seqtrack(integer, bigint)
6.93.
sequencelastvalue(text)
6.94.
sequencesetvalue(integer, integer, bigint, bigint)
6.95.
setaddsequence(integer, integer, text, text)
6.96.
setaddsequence_int(integer, integer, text, text)
6.97.
setaddtable(integer, integer, text, name, text)
6.98.
setaddtable_int(integer, integer, text, name, text)
6.99.
setdropsequence(integer)
6.100.
setdropsequence_int(integer)
6.101.
setdroptable(integer)
6.102.
setdroptable_int(integer)
6.103.
setmovesequence(integer, integer)
6.104.
setmovesequence_int(integer, integer)
6.105.
setmovetable(integer, integer)
6.106.
setmovetable_int(integer, integer)
6.107.
slon_quote_brute(text)
6.108.
slon_quote_input(text)
6.109.
slonyversion()
6.110.
slonyversionmajor()
6.111.
slonyversionminor()
6.112.
slonyversionpatchlevel()
6.113.
storelisten(integer, integer, integer)
6.114.
storelisten_int(integer, integer, integer)
6.115.
storenode(integer, text)
6.116.
storenode_int(integer, text)
6.117.
storepath(integer, integer, text, integer)
6.118.
storepath_int(integer, integer, text, integer)
6.119.
storeset(integer, text)
6.120.
storeset_int(integer, integer, text)
6.121.
subscribeset(integer, integer, integer, boolean, boolean)
6.122.
subscribeset_int(integer, integer, integer, boolean, boolean)
6.123.
tablestovacuum()
6.124.
terminatenodeconnections(integer)
6.125.
uninstallnode()
6.126.
unlockset(integer)
6.127.
unsubscribeset(integer, integer)
6.128.
unsubscribeset_int(integer, integer)
6.129.
updaterelname(integer, integer)
6.130.
updatereloid(integer, integer)
6.131.
upgradeschema(text)
Index
List of Tables
4-1.
Trigger Behaviour
5-1.
Supported Platforms
List of Figures
6-1.
Definition of view sl_seqlastvalue
Next
Preface