Slony-I 2.0.4 Documentation
The PostgreSQL Global Development Group
Christopher Browne
Copyright © 2004-2009 The PostgreSQL Global Development Group
- Table of Contents
- 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. Slony-I Trigger Handling
- 12. Locking Issues
- 13. Race Conditions and Slony-I
- 14. A Task-Oriented View of Slony-I
- 15. Dropping things from Slony-I Replication
- 16. Log Shipping - Slony-I with Files
- 17. Database Schema Changes (DDL)
- 18. Using Slonik
- 19. Embedding Slonik in Shell Scripts
- 20. Not Using Slonik - Bare Metal Slony-I Functions
- 21. Slony-I Administration Scripts
- 22. Partitioning Support
- 23. Slony-I Upgrade
- 24. Using Slony-I for PostgreSQL Upgrades
- 25. Slony-I Test Bed Framework
- 26. Log Analysis
- 27. More Slony-I Help
- 28. Slony-I Supported Platforms
- 29. Release Checklist
- 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. add_empty_table_to_replication(integer, integer, text, text, text, text)
- 1.20. add_missing_table_field(text, text, text, text)
- 1.21. addpartiallogindices()
- 1.22. altertableaddtriggers(integer)
- 1.23. altertableconfiguretriggers(integer)
- 1.24. altertabledroptriggers(integer)
- 1.25. altertablerestore(integer)
- 1.26. checkmoduleversion()
- 1.27. cleanupevent(interval, boolean)
- 1.28. cleanupnodelock()
- 1.29. clonenodefinish(integer, integer)
- 1.30. clonenodeprepare(integer, integer, text)
- 1.31. clonenodeprepare_int(integer, integer, text)
- 1.32. copyfields(integer)
- 1.33. createevent(name, text)
- 1.34. createevent(name, text, text)
- 1.35. createevent(name, text, text, text)
- 1.36. createevent(name, text, text, text, text)
- 1.37. createevent(name, text, text, text, text, text)
- 1.38. createevent(name, text, text, text, text, text, text)
- 1.39. createevent(name, text, text, text, text, text, text, text)
- 1.40. createevent(name, text, text, text, text, text, text, text, text)
- 1.41. createevent(name, text, text, text, text, text, text, text, text, text)
- 1.42. ddlscript_complete(integer, text, integer)
- 1.43. ddlscript_complete_int(integer, integer)
- 1.44. ddlscript_prepare(integer, integer)
- 1.45. ddlscript_prepare_int(integer, integer)
- 1.46. denyaccess()
- 1.47. determineattkindunique(text, name)
- 1.48. determineidxnameunique(text, name)
- 1.49. disablenode(integer)
- 1.50. disablenode_int(integer)
- 1.51. droplisten(integer, integer, integer)
- 1.52. droplisten_int(integer, integer, integer)
- 1.53. dropnode(integer)
- 1.54. dropnode_int(integer)
- 1.55. droppath(integer, integer)
- 1.56. droppath_int(integer, integer)
- 1.57. dropset(integer)
- 1.58. dropset_int(integer)
- 1.59. enablenode(integer)
- 1.60. enablenode_int(integer)
- 1.61. enablesubscription(integer, integer, integer)
- 1.62. enablesubscription_int(integer, integer, integer)
- 1.63. failednode(integer, integer)
- 1.64. failednode2(integer, integer, integer, bigint, bigint)
- 1.65. failoverset_int(integer, integer, integer, bigint)
- 1.66. finishtableaftercopy(integer)
- 1.67. forwardconfirm(integer, integer, bigint, timestamp without time zone)
- 1.68. generate_sync_event(interval)
- 1.69. getlocalnodeid(name)
- 1.70. getmoduleversion()
- 1.71. initializelocalnode(integer, text)
- 1.72. killbackend(integer, text)
- 1.73. lockedset()
- 1.74. lockset(integer)
- 1.75. logswitch_finish()
- 1.76. logswitch_start()
- 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. preparetableforcopy(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. replicate_partition(integer, text, text, text, text)
- 1.92. seqtrack(integer, bigint)
- 1.93. sequencelastvalue(text)
- 1.94. sequencesetvalue(integer, integer, bigint, bigint)
- 1.95. setaddsequence(integer, integer, text, text)
- 1.96. setaddsequence_int(integer, integer, text, text)
- 1.97. setaddtable(integer, integer, text, name, text)
- 1.98. setaddtable_int(integer, integer, text, name, text)
- 1.99. setdropsequence(integer)
- 1.100. setdropsequence_int(integer)
- 1.101. setdroptable(integer)
- 1.102. setdroptable_int(integer)
- 1.103. setmovesequence(integer, integer)
- 1.104. setmovesequence_int(integer, integer)
- 1.105. setmovetable(integer, integer)
- 1.106. setmovetable_int(integer, integer)
- 1.107. slon_quote_brute(text)
- 1.108. slon_quote_input(text)
- 1.109. slonyversion()
- 1.110. slonyversionmajor()
- 1.111. slonyversionminor()
- 1.112. slonyversionpatchlevel()
- 1.113. storelisten(integer, integer, integer)
- 1.114. storelisten_int(integer, integer, integer)
- 1.115. storenode(integer, text)
- 1.116. storenode_int(integer, text)
- 1.117. storepath(integer, integer, text, integer)
- 1.118. storepath_int(integer, integer, text, integer)
- 1.119. storeset(integer, text)
- 1.120. storeset_int(integer, integer, text)
- 1.121. subscribeset(integer, integer, integer, boolean, boolean)
- 1.122. subscribeset_int(integer, integer, integer, boolean, boolean)
- 1.123. tablestovacuum()
- 1.124. terminatenodeconnections(integer)
- 1.125. uninstallnode()
- 1.126. unlockset(integer)
- 1.127. unsubscribeset(integer, integer)
- 1.128. unsubscribeset_int(integer, integer)
- 1.129. updaterelname(integer, integer)
- 1.130. updatereloid(integer, integer)
- 1.131. upgradeschema(text)
- Index
- List of Tables
- 1. Trigger Behaviour
- 2. Supported Platforms
- List of Figures
- 1-1. Definition of view sl_seqlastvalue