Christopher B. Browne's Home Page
cbbrowne@acm.org
Christopher Browne's Web Pages
PrevNext

Chapter 8. Schema schemadoc

Table of Contents
8.1. Table: sl_archive_counter
8.2. Table: sl_config_lock
8.3. Table: sl_confirm
8.4. Table: sl_event
8.5. Table: sl_listen
8.6. Table: sl_log_1
8.7. Table: sl_log_2
8.8. Table: sl_node
8.9. Table: sl_nodelock
8.10. Table: sl_path
8.11. Table: sl_registry
8.12. View: sl_seqlastvalue
8.13. Table: sl_seqlog
8.14. Table: sl_sequence
8.15. Table: sl_set
8.16. Table: sl_setsync
8.17. Table: sl_subscribe
8.18. Table: sl_table
8.19. add_empty_table_to_replication(integer, integer, text, text, text, text)
8.20. add_missing_table_field(text, text, text, text)
8.21. addpartiallogindices()
8.22. altertableaddtriggers(integer)
8.23. altertableconfiguretriggers(integer)
8.24. altertabledroptriggers(integer)
8.25. checkmoduleversion()
8.26. cleanupevent(p_interval interval)
8.27. cleanupnodelock()
8.28. clonenodefinish(integer, integer)
8.29. clonenodeprepare(integer, integer, text)
8.30. clonenodeprepare_int(integer, integer, text)
8.31. copyfields(integer)
8.32. createevent(name, text)
8.33. createevent(name, text, text)
8.34. createevent(name, text, text, text)
8.35. createevent(name, text, text, text, text)
8.36. createevent(name, text, text, text, text, text)
8.37. createevent(name, text, text, text, text, text, text)
8.38. createevent(name, text, text, text, text, text, text, text)
8.39. createevent(name, text, text, text, text, text, text, text, text)
8.40. createevent(name, text, text, text, text, text, text, text, text, text)
8.41. ddlscript_complete(integer, text, integer)
8.42. ddlscript_complete_int(integer, integer)
8.43. ddlscript_prepare(integer, integer)
8.44. ddlscript_prepare_int(integer, integer)
8.45. denyaccess()
8.46. determineattkindunique(text, name)
8.47. determineidxnameunique(text, name)
8.48. disable_indexes_on_table(i_oid oid)
8.49. disablenode(integer)
8.50. disablenode_int(integer)
8.51. droplisten(integer, integer, integer)
8.52. droplisten_int(integer, integer, integer)
8.53. dropnode(integer)
8.54. dropnode_int(integer)
8.55. droppath(integer, integer)
8.56. droppath_int(integer, integer)
8.57. dropset(integer)
8.58. dropset_int(integer)
8.59. enable_indexes_on_table(i_oid oid)
8.60. enablenode(integer)
8.61. enablenode_int(integer)
8.62. enablesubscription(integer, integer, integer)
8.63. enablesubscription_int(integer, integer, integer)
8.64. failednode(integer, integer)
8.65. failednode2(integer, integer, integer, bigint, bigint)
8.66. failoverset_int(integer, integer, integer, bigint)
8.67. finishtableaftercopy(integer)
8.68. forwardconfirm(integer, integer, bigint, timestamp without time zone)
8.69. generate_sync_event(interval)
8.70. getlocalnodeid(name)
8.71. getmoduleversion()
8.72. initializelocalnode(integer, text)
8.73. killbackend(integer, text)
8.74. lockedset()
8.75. lockset(integer)
8.76. logswitch_finish()
8.77. logswitch_start()
8.78. logtrigger()
8.79. mergeset(integer, integer)
8.80. mergeset_int(integer, integer)
8.81. moveset(integer, integer)
8.82. moveset_int(integer, integer, integer, bigint)
8.83. preparetableforcopy(integer)
8.84. rebuildlistenentries()
8.85. registernodeconnection(integer)
8.86. registry_get_int4(text, integer)
8.87. registry_get_text(text, text)
8.88. registry_get_timestamp(text, timestamp without time zone)
8.89. registry_set_int4(text, integer)
8.90. registry_set_text(text, text)
8.91. registry_set_timestamp(text, timestamp without time zone)
8.92. replicate_partition(integer, text, text, text, text)
8.93. seqtrack(integer, bigint)
8.94. sequencelastvalue(text)
8.95. sequencesetvalue(integer, integer, bigint, bigint)
8.96. setaddsequence(integer, integer, text, text)
8.97. setaddsequence_int(integer, integer, text, text)
8.98. setaddtable(integer, integer, text, name, text)
8.99. setaddtable_int(integer, integer, text, name, text)
8.100. setdropsequence(integer)
8.101. setdropsequence_int(integer)
8.102. setdroptable(integer)
8.103. setdroptable_int(integer)
8.104. setmovesequence(integer, integer)
8.105. setmovesequence_int(integer, integer)
8.106. setmovetable(integer, integer)
8.107. setmovetable_int(integer, integer)
8.108. slon_quote_brute(text)
8.109. slon_quote_input(text)
8.110. slonyversion()
8.111. slonyversionmajor()
8.112. slonyversionminor()
8.113. slonyversionpatchlevel()
8.114. storelisten(integer, integer, integer)
8.115. storelisten_int(integer, integer, integer)
8.116. storenode(integer, text)
8.117. storenode_int(integer, text)
8.118. storepath(integer, integer, text, integer)
8.119. storepath_int(integer, integer, text, integer)
8.120. storeset(integer, text)
8.121. storeset_int(integer, integer, text)
8.122. subscribeset(integer, integer, integer, boolean, boolean)
8.123. subscribeset_int(integer, integer, integer, boolean, boolean)
8.124. tablestovacuum()
8.125. terminatenodeconnections(integer)
8.126. uninstallnode()
8.127. unlockset(integer)
8.128. unsubscribeset(integer, integer)
8.129. unsubscribeset_int(integer, integer)
8.130. updaterelname(integer, integer)
8.131. updatereloid(integer, integer)
8.132. upgradeschema(text)

8.1. Table: sl_archive_counter

Table used to generate the log shipping archive number.

Structure of sl_archive_counter

ac_num

bigint

Counter of SYNC ID used in log shipping as the archive number

ac_timestamp

timestamp without time zone

Time at which the archive log was generated on the subscriber

PrevHomeNext
More Slony-I HelpUpTable: sl_config_lock
Google
Contact me at cbbrowne@acm.org