Slony-I 1.2.11 Documentation

The PostgreSQL Global Development Group

Christopher Browne


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. Slony-I "Best Practices"
2. Replicating Your First Database
3. Slon daemons
4. Subscribing Nodes
5. Monitoring
6. Slony-I Maintenance
7. Reshaping a Cluster
8. Doing switchover and failover with Slony-I
9. Slony-I listen paths
10. Slony-I Path Communications
11. Locking Issues
12. A Task-Oriented View of Slony-I
13. Dropping things from Slony-I Replication
14. Log Shipping - Slony-I with Files
15. Database Schema Changes (DDL)
16. Using Slonik
17. Embedding Slonik in Shell Scripts
18. Not Using Slonik - Bare Metal Slony-I Functions
19. Slony-I Administration Scripts
20. Slony-I Upgrade
21. Using Slony-I for PostgreSQL Upgrades
22. Slony-I Test Bed Framework
23. Log Analysis
24. 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_archive_counter
1.2. Table: sl_config_lock
1.3. Table: sl_confirm
1.4. Table: sl_event
1.5. Table: sl_listen
1.6. Table: sl_log_1
1.7. Table: sl_log_2
1.8. Table: sl_node
1.9. Table: sl_nodelock
1.10. Table: sl_path
1.11. Table: sl_registry
1.12. View: sl_seqlastvalue
1.13. Table: sl_seqlog
1.14. Table: sl_sequence
1.15. Table: sl_set
1.16. Table: sl_setsync
1.17. Table: sl_subscribe
1.18. Table: sl_table
1.19. Table: sl_trigger
1.20. add_missing_table_field( text, text, text, text )
1.21. addpartiallogindices( )
1.22. altertableforreplication( integer )
1.23. altertablerestore( integer )
1.24. checkmoduleversion( )
1.25. cleanupevent( )
1.26. cleanupnodelock( )
1.27. copyfields( integer )
1.28. createevent( name, text )
1.29. createevent( name, text, text )
1.30. createevent( name, text, text, text )
1.31. createevent( name, text, text, text, text )
1.32. createevent( name, text, text, text, text, text )
1.33. createevent( name, text, text, text, text, text, text )
1.34. createevent( name, text, text, text, text, text, text, text )
1.35. createevent( name, text, text, text, text, text, text, text, text )
1.36. createevent( name, text, text, text, text, text, text, text, text, text )
1.37. ddlscript_complete( integer, text, integer )
1.38. ddlscript_complete_int( integer, integer )
1.39. ddlscript_prepare( integer, integer )
1.40. ddlscript_prepare_int( integer, integer )
1.41. denyaccess( )
1.42. determineattkindserial( text )
1.43. determineattkindunique( text, name )
1.44. determineidxnameserial( text )
1.45. determineidxnameunique( text, name )
1.46. disablenode( integer )
1.47. disablenode_int( integer )
1.48. droplisten( integer, integer, integer )
1.49. droplisten_int( integer, integer, integer )
1.50. dropnode( integer )
1.51. dropnode_int( integer )
1.52. droppath( integer, integer )
1.53. droppath_int( integer, integer )
1.54. dropset( integer )
1.55. dropset_int( integer )
1.56. droptrigger( integer, name )
1.57. droptrigger_int( integer, name )
1.58. enablenode( integer )
1.59. enablenode_int( integer )
1.60. enablesubscription( integer, integer, integer )
1.61. enablesubscription_int( integer, integer, integer )
1.62. failednode( integer, integer )
1.63. failednode2( integer, integer, integer, bigint, bigint )
1.64. failoverset_int( integer, integer, integer, bigint )
1.65. forwardconfirm( integer, integer, bigint, timestamp without time zone )
1.66. generate_sync_event( interval )
1.67. getlocalnodeid( name )
1.68. getmoduleversion( )
1.69. getsessionrole( name )
1.70. initializelocalnode( integer, text )
1.71. killbackend( integer, text )
1.72. lockedset( )
1.73. lockset( integer )
1.74. logswitch_finish( )
1.75. logswitch_start( )
1.76. logswitch_weekly( )
1.77. logtrigger( )
1.78. mergeset( integer, integer )
1.79. mergeset_int( integer, integer )
1.80. moveset( integer, integer )
1.81. moveset_int( integer, integer, integer, bigint )
1.82. reachablefromnode( integer, integer[] )
1.83. rebuildlistenentries( )
1.84. registernodeconnection( integer )
1.85. registry_get_int4( text, integer )
1.86. registry_get_text( text, text )
1.87. registry_get_timestamp( text, timestamp without time zone )
1.88. registry_set_int4( text, integer )
1.89. registry_set_text( text, text )
1.90. registry_set_timestamp( text, timestamp without time zone )
1.91. sequencelastvalue( text )
1.92. sequencesetvalue( integer, integer, bigint, bigint )
1.93. setaddsequence( integer, integer, text, text )
1.94. setaddsequence_int( integer, integer, text, text )
1.95. setaddtable( integer, integer, text, name, text )
1.96. setaddtable_int( integer, integer, text, name, text )
1.97. setdropsequence( integer )
1.98. setdropsequence_int( integer )
1.99. setdroptable( integer )
1.100. setdroptable_int( integer )
1.101. setmovesequence( integer, integer )
1.102. setmovesequence_int( integer, integer )
1.103. setmovetable( integer, integer )
1.104. setmovetable_int( integer, integer )
1.105. setsessionrole( name, text )
1.106. slon_quote_brute( text )
1.107. slon_quote_input( text )
1.108. slonyversion( )
1.109. slonyversionmajor( )
1.110. slonyversionminor( )
1.111. slonyversionpatchlevel( )
1.112. storelisten( integer, integer, integer )
1.113. storelisten_int( integer, integer, integer )
1.114. storenode( integer, text, boolean )
1.115. storenode_int( integer, text, boolean )
1.116. storepath( integer, integer, text, integer )
1.117. storepath_int( integer, integer, text, integer )
1.118. storeset( integer, text )
1.119. storeset_int( integer, integer, text )
1.120. storetrigger( integer, name )
1.121. storetrigger_int( integer, name )
1.122. subscribeset( integer, integer, integer, boolean )
1.123. subscribeset_int( integer, integer, integer, boolean )
1.124. tableaddkey( text )
1.125. tabledropkey( integer )
1.126. tablehasserialkey( text )
1.127. terminatenodeconnections( integer )
1.128. uninstallnode( )
1.129. unlockset( integer )
1.130. unsubscribeset( integer, integer )
1.131. unsubscribeset_int( integer, integer )
1.132. updaterelname( integer, integer )
1.133. updatereloid( integer, integer )
1.134. upgradeschema( text )
Index
List of Tables
1. Supported Platforms
List of Figures
1-1. Definition of view sl_seqlastvalue