Documentation Slony-I 1.2.21 -

1. Schéma 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. Vue : 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_empty_table_to_replication( integer, integer, text, text, text, text )
1.21. add_empty_table_to_replication( integer, integer, text, text, text, text )
1.22. add_missing_table_field( text, text, text, text )
1.23. addpartiallogindices( )
1.24. altertableforreplication( integer )
1.25. altertablerestore( integer )
1.26. checkmoduleversion( )
1.27. cleanupevent( )
1.28. cleanupnodelock( )
1.29. copyfields( integer )
1.30. createevent( name, text )
1.31. createevent( name, text, text )
1.32. createevent( name, text, text, text )
1.33. createevent( name, text, text, text, text )
1.34. createevent( name, text, text, text, text, text )
1.35. createevent( name, text, text, text, text, text, text )
1.36. createevent( name, text, text, text, text, text, text, text )
1.37. createevent( name, text, text, text, text, text, text, text, text )
1.38. createevent( name, text, text, text, text, text, text, text, text, text )
1.39. ddlscript_complete( integer, text, integer )
1.40. ddlscript_complete_int( integer, integer )
1.41. ddlscript_prepare( integer, integer )
1.42. ddlscript_prepare_int( integer, integer )
1.43. denyaccess( )
1.44. determineattkindserial( text )
1.45. determineattkindunique( text, name )
1.46. determineidxnameserial( text )
1.47. determineidxnameunique( text, name )
1.48. disablenode( integer )
1.49. disablenode_int( integer )
1.50. droplisten( integer, integer, integer )
1.51. droplisten_int( integer, integer, integer )
1.52. dropnode( integer )
1.53. dropnode_int( integer )
1.54. droppath( integer, integer )
1.55. droppath_int( integer, integer )
1.56. id="function.dropset-integer-titleabbrev"> dropset( integer )
1.57. id="function.dropset-int-integer-titleabbrev"> dropset_int( integer )
1.58. id="function.droptrigger-integer-name-titleabbrev"> droptrigger( integer, name )
1.59. id="function.droptrigger-int-integer-name-titleabbrev"> droptrigger_int( integer, name )
1.60. id="function.enablenode-integer-titleabbrev"> enablenode( integer )
1.61. id="function.enablenode-int-integer-titleabbrev"> enablenode_int( integer )
1.62. id="function.enablesubscription-integer-integer-integer-titleabbrev"> enablesubscription( integer, integer, integer )
1.63. id="function.enablesubscription-int-integer-integer-integer-titleabbrev"> enablesubscription_int( integer, integer, integer )
1.64. id="function.failednode-integer-integer-titleabbrev"> failednode( integer, integer )
1.65. id="function.failednode2-integer-integer-integer-bigint-bigint-titleabbrev"> failednode2( integer, integer, integer, bigint, bigint )
1.66. failoverset_int( integer, integer, integer, bigint )
1.67. id="function.forwardconfirm-integer-integer-bigint-timestamp-without-time-zone-titleabbrev"> forwardconfirm( integer, integer, bigint, timestamp without time zone )
1.68. id="function.generate-sync-event-interval-titleabbrev"> generate_sync_event( interval )
1.69. id="function.getlocalnodeid-name-titleabbrev"> getlocalnodeid( name )
1.70. id="function.getmoduleversion-titleabbrev"> getmoduleversion( )
1.71. id="function.getsessionrole-name-titleabbrev"> getsessionrole( name )
1.72. id="function.initializelocalnode-integer-text-titleabbrev"> initializelocalnode( integer, text )
1.73. id="function.killbackend-integer-text-titleabbrev"> killbackend( integer, text )
1.74. id="function.lockedset-titleabbrev"> lockedset( )
1.75. id="function.lockset-integer-titleabbrev"> lockset( integer )
1.76. id="function.logswitch-finish-titleabbrev"> logswitch_finish( )
1.77. id="function.logswitch-start-titleabbrev"> logswitch_start( )
1.78. id="function.logswitch-weekly-titleabbrev"> logswitch_weekly( )
1.79. id="function.logtrigger-titleabbrev"> logtrigger( )
1.80. id="function.mergeset-integer-integer-titleabbrev"> mergeset( integer, integer )
1.81. id="function.mergeset-int-integer-integer-titleabbrev"> mergeset_int( integer, integer )
1.82. id="function.moveset-integer-integer-titleabbrev"> moveset( integer, integer )
1.83. moveset_int( integer, integer, integer, bigint )
1.84. id="function.reachablefromnode-integer-integerARRAY-titleabbrev"> reachablefromnode( integer, integer[] )
1.85. id="function.rebuildlistenentries-titleabbrev"> rebuildlistenentries( )
1.86. id="function.registernodeconnection-integer-titleabbrev"> registernodeconnection( integer )
1.87. id="function.registry-get-int4-text-integer-titleabbrev"> registry_get_int4( text, integer )
1.88. id="function.registry-get-text-text-text-titleabbrev"> registry_get_text( text, text )
1.89. id="function.registry-get-timestamp-text-timestamp-without-time-zone-titleabbrev"> registry_get_timestamp( text, timestamp without time zone )
1.90. id="function.registry-set-int4-text-integer-titleabbrev"> registry_set_int4( text, integer )
1.91. id="function.registry-set-text-text-text-titleabbrev"> registry_set_text( text, text )
1.92. id="function.registry-set-timestamp-text-timestamp-without-time-zone-titleabbrev"> registry_set_timestamp( text, timestamp without time zone )
1.93. id="function.replicate-partition-integer-text-text-text-text-titleabbrev"> replicate_partition( integer, text, text, text, text )
1.94. id="function.sequencelastvalue-text-titleabbrev"> sequencelastvalue( text )
1.95. id="function.sequencesetvalue-integer-integer-bigint-bigint-titleabbrev"> sequencesetvalue( integer, integer, bigint, bigint )
1.96. id="function.setaddsequence-integer-integer-text-text-titleabbrev"> setaddsequence( integer, integer, text, text )
1.97. id="function.setaddsequence-int-integer-integer-text-text-titleabbrev"> setaddsequence_int( integer, integer, text, text )
1.98. id="function.setaddtable-integer-integer-text-name-text-titleabbrev"> setaddtable( integer, integer, text, name, text )
1.99. id="function.setaddtable-int-integer-integer-text-name-text-titleabbrev"> setaddtable_int( integer, integer, text, name, text )
1.100. id="function.setdropsequence-integer-titleabbrev"> setdropsequence( integer )
1.101. id="function.setdropsequence-int-integer-titleabbrev"> setdropsequence_int( integer )
1.102. id="function.setdroptable-integer-titleabbrev"> setdroptable( integer )
1.103. id="function.setdroptable-int-integer-titleabbrev"> setdroptable_int( integer )
1.104. id="function.setmovesequence-integer-integer-titleabbrev"> setmovesequence( integer, integer )
1.105. id="function.setmovesequence-int-integer-integer-titleabbrev"> setmovesequence_int( integer, integer )
1.106. id="function.setmovetable-integer-integer-titleabbrev"> setmovetable( integer, integer )
1.107. id="function.setmovetable-int-integer-integer-titleabbrev"> setmovetable_int( integer, integer )
1.108. id="function.setsessionrole-name-text-titleabbrev"> setsessionrole( name, text )
1.109. id="function.slon-quote-brute-text-titleabbrev"> slon_quote_brute( text )
1.110. id="function.slon-quote-input-text-titleabbrev"> slon_quote_input( text )
1.111. id="function.slonyversion-titleabbrev"> slonyversion( )
1.112. id="function.slonyversionmajor-titleabbrev"> slonyversionmajor( )
1.113. id="function.slonyversionminor-titleabbrev"> slonyversionminor( )
1.114. id="function.slonyversionpatchlevel-titleabbrev"> slonyversionpatchlevel( )
1.115. id="function.storelisten-integer-integer-integer-titleabbrev"> storelisten( integer, integer, integer )
1.116. id="function.storelisten-int-integer-integer-integer-titleabbrev"> storelisten_int( integer, integer, integer )
1.117. id="function.storenode-integer-text-boolean-titleabbrev"> storenode( integer, text, boolean )
1.118. id="function.storenode-int-integer-text-boolean-titleabbrev"> storenode_int( integer, text, boolean )
1.119. id="function.storepath-integer-integer-text-integer-titleabbrev"> storepath( integer, integer, text, integer )
1.120. id="function.storepath-int-integer-integer-text-integer-titleabbrev"> storepath_int( integer, integer, text, integer )
1.121. id="function.storeset-integer-text-titleabbrev"> storeset( integer, text )
1.122. id="function.storeset-int-integer-integer-text-titleabbrev"> storeset_int( integer, integer, text )
1.123. id="function.storetrigger-integer-name-titleabbrev"> storetrigger( integer, name )
1.124. id="function.storetrigger-int-integer-name-titleabbrev"> storetrigger_int( integer, name )
1.125. id="function.subscribeset-integer-integer-integer-boolean-titleabbrev"> subscribeset( integer, integer, integer, boolean )
1.126. id="function.subscribeset-int-integer-integer-integer-boolean-titleabbrev"> subscribeset_int( integer, integer, integer, boolean )
1.127. id="function.tableaddkey-text-titleabbrev"> tableaddkey( text )
1.128. id="function.tabledropkey-integer-titleabbrev"> tabledropkey( integer )
1.129. id="function.tablehasserialkey-text-titleabbrev"> tablehasserialkey( text )
1.130. id="function.terminatenodeconnections-integer-titleabbrev"> terminatenodeconnections( integer )
1.131. id="function.uninstallnode-titleabbrev"> uninstallnode( )
1.132. id="function.unlockset-integer-titleabbrev"> unlockset( integer )
1.133. id="function.unsubscribeset-integer-integer-titleabbrev"> unsubscribeset( integer, integer )
1.134. id="function.unsubscribeset-int-integer-integer-titleabbrev"> unsubscribeset_int( integer, integer )
1.135. id="function.updaterelname-integer-integer-titleabbrev"> updaterelname( integer, integer )
1.136. id="function.updatereloid-integer-integer-titleabbrev"> updatereloid( integer, integer )
1.137. id="function.upgradeschema-text-titleabbrev"> upgradeschema( text )

1.1.  Table : sl_archive_counter

Table utilisée pour générer le numéro d'archive du log shipping.

Structure de sl_archive_counter

ac_num

bigint

Compteur de l'identifiant SYNC utilisé dans le log shipping comme numéro d'archive

ac_timestamp

timestamp without time zone

Horodatage de la génération du log d'archive sur l'abonné

PrécédentSLONIK CLONE FINISH Sommaire Table : sl_config_lock Suivant