Slony-I

Slony-I 2.0.8 Documentation

The PostgreSQL Global Development Group

Christopher Browne

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. Release Checklist
5.4. 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. decode_tgargs(bytea)
6.46. denyaccess()
6.47. determineattkindunique(text, name)
6.48. determineidxnameunique(text, name)
6.49. disablenode(integer)
6.50. disablenode_int(integer)
6.51. droplisten(integer, integer, integer)
6.52. droplisten_int(integer, integer, integer)
6.53. dropnode(integer)
6.54. dropnode_int(integer)
6.55. droppath(integer, integer)
6.56. droppath_int(integer, integer)
6.57. dropset(integer)
6.58. dropset_int(integer)
6.59. enablenode(integer)
6.60. enablenode_int(integer)
6.61. enablesubscription(integer, integer, integer)
6.62. enablesubscription_int(integer, integer, integer)
6.63. failednode(integer, integer)
6.64. failednode2(integer, integer, integer, bigint, bigint)
6.65. failoverset_int(integer, integer, integer, bigint)
6.66. finishtableaftercopy(integer)
6.67. forwardconfirm(integer, integer, bigint, timestamp without time zone)
6.68. generate_sync_event(interval)
6.69. getlocalnodeid(name)
6.70. getmoduleversion()
6.71. initializelocalnode(integer, text)
6.72. killbackend(integer, text)
6.73. lockedset()
6.74. lockset(integer)
6.75. logswitch_finish()
6.76. logswitch_start()
6.77. logtrigger()
6.78. mergeset(integer, integer)
6.79. mergeset_int(integer, integer)
6.80. moveset(integer, integer)
6.81. moveset_int(integer, integer, integer, bigint)
6.82. preparetableforcopy(integer)
6.83. rebuildlistenentries()
6.84. recreate_log_trigger(p_tab_attkind text, p_tab_id oid, p_fq_table_name text)
6.85. registernodeconnection(integer)
6.86. registry_get_int4(text, integer)
6.87. registry_get_text(text, text)
6.88. registry_get_timestamp(text, timestamp without time zone)
6.89. registry_set_int4(text, integer)
6.90. registry_set_text(text, text)
6.91. registry_set_timestamp(text, timestamp without time zone)
6.92. repair_log_triggers(only_locked boolean)
6.93. replicate_partition(integer, text, text, text, text)
6.94. reshapesubscription(integer, integer, integer)
6.95. seqtrack(integer, bigint)
6.96. sequencelastvalue(text)
6.97. sequencesetvalue(integer, integer, bigint, bigint)
6.98. setaddsequence(integer, integer, text, text)
6.99. setaddsequence_int(integer, integer, text, text)
6.100. setaddtable(integer, integer, text, name, text)
6.101. setaddtable_int(integer, integer, text, name, text)
6.102. setdropsequence(integer)
6.103. setdropsequence_int(integer)
6.104. setdroptable(integer)
6.105. setdroptable_int(integer)
6.106. setmovesequence(integer, integer)
6.107. setmovesequence_int(integer, integer)
6.108. setmovetable(integer, integer)
6.109. setmovetable_int(integer, integer)
6.110. slon_quote_brute(text)
6.111. slon_quote_input(text)
6.112. slonyversion()
6.113. slonyversionmajor()
6.114. slonyversionminor()
6.115. slonyversionpatchlevel()
6.116. storelisten(integer, integer, integer)
6.117. storelisten_int(integer, integer, integer)
6.118. storenode(integer, text)
6.119. storenode_int(integer, text)
6.120. storepath(integer, integer, text, integer)
6.121. storepath_int(integer, integer, text, integer)
6.122. storeset(integer, text)
6.123. storeset_int(integer, integer, text)
6.124. subscribeset(integer, integer, integer, boolean, boolean)
6.125. subscribeset_int(integer, integer, integer, boolean, boolean)
6.126. tablestovacuum()
6.127. terminatenodeconnections(integer)
6.128. uninstallnode()
6.129. unlockset(integer)
6.130. unsubscribeset(integer, integer)
6.131. unsubscribeset_int(integer, integer)
6.132. updaterelname(integer, integer)
6.133. updatereloid(integer, integer)
6.134. upgradeschema(text)

Index

List of Tables
4-1. Trigger Behaviour

List of Figures
6-1. Definition of view sl_seqlastvalue

		Next
		Preface