Documentation Slony-I
2.0.3

Table des matières

Introduction à Slony-I

1. Introduction à Slony-I

2. Coûts de communications avec Slony-I

3. Prérequis système

4. Installation de Slony-I

5. Les concepts

6. Définir les clusters Slony-I

7. Définir les ensembles de réplication

Administration Slony-I

1. Bonnes Pratiques avec Slony-I

2. Répliquer votre première base de données

3. Les démons Slon

4. Enregistrement des serveurs

5. Surveillance

6. Maintenance

7. Restructurer un cluster

8. Effectuer une bascule d'urgence avec Slony-I

9. Voix d'écoute

10. Voies de communication Slony-I

11. Gestion des triggers Slony-I

12. Problèmes de verrous

13. Situations de compétition et Slony-I

14. Ajouter des objets à la réplication

15. Supprimer des éléments de la réplication

16. Log Shipping

17. Changements du schéma de la base (DDL)

18. Utiliser Slonik

19. Utiliser Slonik à partir d'un script shell

20. Ne pas utiliser Slonik - les fonctions Slony-I de bas niveau

21. Scripts d'administration

22. Support du partitionnement

23. Mise à jour de Slony-I

24. Utiliser Slony-I pour les mises à jour PostgreSQL

25. Banc d'essai Slony-I

26. Analyses des traces

27. Plus d'aide sur Slony-I

28. Plate-formes supportées par Slony-I

29. Liste de vérifications pour chaque version

FAQ Slony-I

I. Le Cœur de Slony-I

slon — Le démon Slony-I™

Configuration

slonik — Processeur de commandes Slony-I™

Tour d'horizon des commandes Slonik

I. Méta-commandes Slonik

II. Commandes slonik préliminaires

III. Commande de configuration et d'action

1. Schéma schemadoc

1.1. Table : sl_config_lock

1.2. Table : sl_confirm

1.3. Table : sl_event

1.4. Table : sl_listen

1.5. Table : sl_log_1

1.6. Table : sl_log_2

1.7. Table : sl_node

1.8. Table : sl_nodelock

1.9. Table : sl_path

1.10. Table : sl_registry

1.11. Vue : sl_seqlastvalue

1.12. Table : sl_seqlog

1.13. Table : sl_sequence

1.14. Table : sl_set

1.15. Table : sl_setsync

1.16. Table : sl_subscribe

1.17. Table : sl_table

1.18. Table : sl_trigger

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. 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. id="function.dropset-integer-titleabbrev"> dropset( integer )

1.55. id="function.dropset-int-integer-titleabbrev"> dropset_int( integer )

1.56. id="function.droptrigger-integer-name-titleabbrev"> droptrigger( integer, name )

1.57. id="function.droptrigger-int-integer-name-titleabbrev"> droptrigger_int( integer, name )

1.58. id="function.enablenode-integer-titleabbrev"> enablenode( integer )

1.59. id="function.enablenode-int-integer-titleabbrev"> enablenode_int( integer )

1.60. id="function.enablesubscription-integer-integer-integer-titleabbrev"> enablesubscription( integer, integer, integer )

1.61. id="function.enablesubscription-int-integer-integer-integer-titleabbrev"> enablesubscription_int( integer, integer, integer )

1.62. id="function.failednode-integer-integer-titleabbrev"> failednode( integer, integer )

1.63. id="function.failednode2-integer-integer-integer-bigint-bigint-titleabbrev"> failednode2( integer, integer, integer, bigint, bigint )

1.64. failoverset_int( integer, integer, integer )

1.65. id="function.forwardconfirm-integer-integer-bigint-timestamp-without-time-zone-titleabbrev"> forwardconfirm( integer, integer, bigint, timestamp without time zone )

1.66. id="function.generate-sync-event-interval-titleabbrev"> generate_sync_event( interval )

1.67. id="function.getlocalnodeid-name-titleabbrev"> getlocalnodeid( name )

1.68. id="function.getmoduleversion-titleabbrev"> getmoduleversion( )

1.69. id="function.getsessionrole-name-titleabbrev"> getsessionrole( name )

1.70. id="function.initializelocalnode-integer-text-titleabbrev"> initializelocalnode( integer, text )

1.71. id="function.killbackend-integer-text-titleabbrev"> killbackend( integer, text )

1.72. id="function.lockedset-titleabbrev"> lockedset( )

1.73. id="function.lockset-integer-titleabbrev"> lockset( integer )

1.74. id="function.logswitch-finish-titleabbrev"> logswitch_finish( )

1.75. id="function.logswitch-start-titleabbrev"> logswitch_start( )

1.76. id="function.logswitch-weekly-titleabbrev"> logswitch_weekly( )

1.77. id="function.logtrigger-titleabbrev"> logtrigger( )

1.78. id="function.mergeset-integer-integer-titleabbrev"> mergeset( integer, integer )

1.79. id="function.mergeset-int-integer-integer-titleabbrev"> mergeset_int( integer, integer )

1.80. id="function.moveset-integer-integer-titleabbrev"> moveset( integer, integer )

1.81. moveset_int( integer, integer, integer )

1.82. id="function.reachablefromnode-integer-integerARRAY-titleabbrev"> reachablefromnode( integer, integer[] )

1.83. id="function.rebuildlistenentries-titleabbrev"> rebuildlistenentries( )

1.84. id="function.registernodeconnection-integer-titleabbrev"> registernodeconnection( integer )

1.85. id="function.registry-get-int4-text-integer-titleabbrev"> registry_get_int4( text, integer )

1.86. id="function.registry-get-text-text-text-titleabbrev"> registry_get_text( text, text )

1.87. id="function.registry-get-timestamp-text-timestamp-without-time-zone-titleabbrev"> registry_get_timestamp( text, timestamp without time zone )

1.88. id="function.registry-set-int4-text-integer-titleabbrev"> registry_set_int4( text, integer )

1.89. id="function.registry-set-text-text-text-titleabbrev"> registry_set_text( text, text )

1.90. id="function.registry-set-timestamp-text-timestamp-without-time-zone-titleabbrev"> registry_set_timestamp( text, timestamp without time zone )

1.91. id="function.sequencelastvalue-text-titleabbrev"> sequencelastvalue( text )

1.92. id="function.sequencesetvalue-integer-integer-bigint-bigint-titleabbrev"> sequencesetvalue( integer, integer, bigint, bigint )

1.93. id="function.setaddsequence-integer-integer-text-text-titleabbrev"> setaddsequence( integer, integer, text, text )

1.94. id="function.setaddsequence-int-integer-integer-text-text-titleabbrev"> setaddsequence_int( integer, integer, text, text )

1.95. id="function.setaddtable-integer-integer-text-name-text-titleabbrev"> setaddtable( integer, integer, text, name, text )

1.96. id="function.setaddtable-int-integer-integer-text-name-text-titleabbrev"> setaddtable_int( integer, integer, text, name, text )

1.97. id="function.setdropsequence-integer-titleabbrev"> setdropsequence( integer )

1.98. id="function.setdropsequence-int-integer-titleabbrev"> setdropsequence_int( integer )

1.99. id="function.setdroptable-integer-titleabbrev"> setdroptable( integer )

1.100. id="function.setdroptable-int-integer-titleabbrev"> setdroptable_int( integer )

1.101. id="function.setmovesequence-integer-integer-titleabbrev"> setmovesequence( integer, integer )

1.102. id="function.setmovesequence-int-integer-integer-titleabbrev"> setmovesequence_int( integer, integer )

1.103. id="function.setmovetable-integer-integer-titleabbrev"> setmovetable( integer, integer )

1.104. id="function.setmovetable-int-integer-integer-titleabbrev"> setmovetable_int( integer, integer )

1.105. id="function.setsessionrole-name-text-titleabbrev"> setsessionrole( name, text )

1.106. id="function.slon-quote-brute-text-titleabbrev"> slon_quote_brute( text )

1.107. id="function.slon-quote-input-text-titleabbrev"> slon_quote_input( text )

1.108. id="function.slonyversion-titleabbrev"> slonyversion( )

1.109. id="function.slonyversionmajor-titleabbrev"> slonyversionmajor( )

1.110. id="function.slonyversionminor-titleabbrev"> slonyversionminor( )

1.111. id="function.slonyversionpatchlevel-titleabbrev"> slonyversionpatchlevel( )

1.112. id="function.storelisten-integer-integer-integer-titleabbrev"> storelisten( integer, integer, integer )

1.113. id="function.storelisten-int-integer-integer-integer-titleabbrev"> storelisten_int( integer, integer, integer )

1.114. id="function.storenode-integer-text-boolean-titleabbrev"> storenode( integer, text, boolean )

1.115. id="function.storenode-int-integer-text-boolean-titleabbrev"> storenode_int( integer, text, boolean )

1.116. id="function.storepath-integer-integer-text-integer-titleabbrev"> storepath( integer, integer, text, integer )

1.117. id="function.storepath-int-integer-integer-text-integer-titleabbrev"> storepath_int( integer, integer, text, integer )

1.118. id="function.storeset-integer-text-titleabbrev"> storeset( integer, text )

1.119. id="function.storeset-int-integer-integer-text-titleabbrev"> storeset_int( integer, integer, text )

1.120. id="function.storetrigger-integer-name-titleabbrev"> storetrigger( integer, name )

1.121. id="function.storetrigger-int-integer-name-titleabbrev"> storetrigger_int( integer, name )

1.122. id="function.subscribeset-integer-integer-integer-boolean-titleabbrev"> subscribeset( integer, integer, integer, boolean )

1.123. id="function.subscribeset-int-integer-integer-integer-boolean-titleabbrev"> subscribeset_int( integer, integer, integer, boolean )

1.124. id="function.tableaddkey-text-titleabbrev"> tableaddkey( text )

1.125. id="function.tabledropkey-integer-titleabbrev"> tabledropkey( integer )

1.126. id="function.tablehasserialkey-text-titleabbrev"> tablehasserialkey( text )

1.127. id="function.terminatenodeconnections-integer-titleabbrev"> terminatenodeconnections( integer )

1.128. id="function.uninstallnode-titleabbrev"> uninstallnode( )

1.129. id="function.unlockset-integer-titleabbrev"> unlockset( integer )

1.130. id="function.unsubscribeset-integer-integer-titleabbrev"> unsubscribeset( integer, integer )

1.131. id="function.unsubscribeset-int-integer-integer-titleabbrev"> unsubscribeset_int( integer, integer )

1.132. id="function.updaterelname-integer-integer-titleabbrev"> updaterelname( integer, integer )

1.133. id="function.updatereloid-integer-integer-titleabbrev"> updatereloid( integer, integer )

1.134. id="function.upgradeschema-text-titleabbrev"> upgradeschema( text )

A. Traduction française