/usr/share/doc/slony1-2-doc/adminguide/index.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Slony-I 2.2.4 Documentation</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:slony1-general@lists.slony.info"><LINK
REL="NEXT"
TITLE="Preface"
HREF="preface.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="BOOK"
><DIV
CLASS="BOOK"
><A
NAME="SLONY"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="TITLE"
><A
NAME="SLONY"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> 2.2.4 Documentation</A
></H1
><H3
CLASS="CORPAUTHOR"
>The PostgreSQL Global Development Group</H3
><H3
CLASS="AUTHOR"
><A
NAME="AEN6"
></A
>Christopher Browne</H3
><P
CLASS="COPYRIGHT"
><A
HREF="LEGALNOTICE.html"
>Copyright</A
> &copy; 2004-2013 The PostgreSQL Global Development Group</P
><HR></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>1. <A
HREF="preface.html"
>Preface</A
></DT
><DD
><DL
><DT
>1.1. <A
HREF="preface.html#INTRODUCTION"
>Introduction to <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
></A
></DT
><DT
>1.2. <A
HREF="requirements.html"
>System Requirements</A
></DT
><DT
>1.3. <A
HREF="concepts.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Concepts</A
></DT
><DT
>1.4. <A
HREF="limitations.html"
>Current Limitations</A
></DT
></DL
></DD
><DT
>2. <A
HREF="tutorial.html"
>Tutorial</A
></DT
><DD
><DL
><DT
>2.1. <A
HREF="tutorial.html#FIRSTDB"
>Replicating Your First Database</A
></DT
><DT
>2.2. <A
HREF="startingstopping.html"
>Starting &#38; Stopping Replication</A
></DT
></DL
></DD
><DT
>3. <A
HREF="administration.html"
>Administration Tasks</A
></DT
><DD
><DL
><DT
>3.1. <A
HREF="administration.html#INSTALLATION"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Building &#38; Installation</A
></DT
><DT
>3.2. <A
HREF="modifyingthings.html"
>Modifying Things in a Replication Cluster</A
></DT
><DT
>3.3. <A
HREF="ddlchanges.html"
>Database Schema Changes (DDL)</A
></DT
><DT
>3.4. <A
HREF="failover.html"
>Doing switchover and failover with <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
></A
></DT
></DL
></DD
><DT
>4. <A
HREF="advanced.html"
>Advanced Concepts</A
></DT
><DD
><DL
><DT
>4.1. <A
HREF="advanced.html#EVENTS"
>Events &#38; Confirmations</A
></DT
><DT
>4.2. <A
HREF="listenpaths.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Listen Paths</A
></DT
><DT
>4.3. <A
HREF="triggers.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Trigger Handling</A
></DT
><DT
>4.4. <A
HREF="locking.html"
>Locking Issues</A
></DT
><DT
>4.5. <A
HREF="logshipping.html"
>Log Shipping - <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> with Files</A
></DT
></DL
></DD
><DT
>5. <A
HREF="deploymentconcerns.html"
>Deployment Considerations</A
></DT
><DD
><DL
><DT
>5.1. <A
HREF="deploymentconcerns.html#MONITORING"
>Cluster Monitoring</A
></DT
><DT
>5.2. <A
HREF="componentmonitoring.html"
>Component Monitoring</A
></DT
><DT
>5.3. <A
HREF="partitioning.html"
>Partitioning Support</A
></DT
><DT
>5.4. <A
HREF="slonyupgrade.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Upgrade</A
></DT
><DT
>5.5. <A
HREF="loganalysis.html"
>Log Analysis</A
></DT
><DT
>5.6. <A
HREF="performance.html"
>Performance Considerations</A
></DT
><DT
>5.7. <A
HREF="security.html"
>Security Considerations</A
></DT
></DL
></DD
><DT
>6. <A
HREF="additionalutils.html"
>Additional Utilities</A
></DT
><DD
><DL
><DT
>6.1. <A
HREF="additionalutils.html#ADMINSCRIPTS"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Administration Scripts</A
></DT
><DT
>6.2. <A
HREF="watchdogs.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Watchdog</A
></DT
><DT
>6.3. <A
HREF="teststate.html"
>Testing <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> State</A
></DT
><DT
>6.4. <A
HREF="logrotation.html"
>Log Files</A
></DT
><DT
>6.5. <A
HREF="mkservice.html"
>mkservice</A
></DT
><DT
>6.6. <A
HREF="testing.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Test Suites</A
></DT
><DT
>6.7. <A
HREF="clustertest.html"
>Clustertest Test Framework</A
></DT
><DT
>6.8. <A
HREF="oldtestbed.html"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Test Bed Framework</A
></DT
></DL
></DD
><DT
>I. <A
HREF="reference.html"
>Reference</A
></DT
><DD
><DL
><DT
><A
HREF="slon.html"
><SPAN
CLASS="APPLICATION"
>slon</SPAN
></A
>&nbsp;--&nbsp;   <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> daemon
  </DT
><DT
><A
HREF="runtime-config.html"
></A
></DT
><DT
><A
HREF="slonik.html"
><SPAN
CLASS="APPLICATION"
>slonik</SPAN
></A
>&nbsp;--&nbsp;      <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> command processor
    </DT
><DT
><A
HREF="slonikref.html"
></A
></DT
><DT
>I. <A
HREF="metacmds.html"
>Slonik Meta Commands</A
></DT
><DT
>II. <A
HREF="hdrcmds.html"
>Slonik Preamble Commands</A
></DT
><DT
>III. <A
HREF="cmds.html"
>Configuration and Action commands</A
></DT
><DT
><A
HREF="slony-logshipping.html"
><SPAN
CLASS="APPLICATION"
>slony_logshipping</SPAN
></A
>&nbsp;--&nbsp;slony_logshippping daemon</DT
></DL
></DD
><DT
>7. <A
HREF="appendix.html"
>Appendix</A
></DT
><DD
><DL
><DT
>7.1. <A
HREF="appendix.html#FAQ"
>Frequently Asked Questions</A
></DT
><DT
>7.2. <A
HREF="releasechecklist.html"
>Release Checklist</A
></DT
><DT
>7.3. <A
HREF="usingslonik.html"
>Using Slonik</A
></DT
><DT
>7.4. <A
HREF="slonikshell.html"
>Embedding Slonik in Shell Scripts</A
></DT
><DT
>7.5. <A
HREF="help.html"
>More <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> Help</A
></DT
></DL
></DD
><DT
>8. <A
HREF="schema.html"
>Schema schemadoc</A
></DT
><DD
><DL
><DT
>8.1. <A
HREF="schema.html#TABLE.SL-APPLY-STATS"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_apply_stats</TT
></A
></DT
><DT
>8.2. <A
HREF="table.sl-archive-counter.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_archive_counter</TT
></A
></DT
><DT
>8.3. <A
HREF="table.sl-components.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_components</TT
></A
></DT
><DT
>8.4. <A
HREF="table.sl-config-lock.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_config_lock</TT
></A
></DT
><DT
>8.5. <A
HREF="table.sl-confirm.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_confirm</TT
></A
></DT
><DT
>8.6. <A
HREF="table.sl-event.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_event</TT
></A
></DT
><DT
>8.7. <A
HREF="table.sl-event-lock.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_event_lock</TT
></A
></DT
><DT
>8.8. <A
HREF="view.sl-failover-targets.html"
>View:
         
         <TT
CLASS="STRUCTNAME"
>sl_failover_targets</TT
></A
></DT
><DT
>8.9. <A
HREF="table.sl-listen.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_listen</TT
></A
></DT
><DT
>8.10. <A
HREF="table.sl-log-1.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_log_1</TT
></A
></DT
><DT
>8.11. <A
HREF="table.sl-log-2.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_log_2</TT
></A
></DT
><DT
>8.12. <A
HREF="table.sl-log-script.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_log_script</TT
></A
></DT
><DT
>8.13. <A
HREF="table.sl-node.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_node</TT
></A
></DT
><DT
>8.14. <A
HREF="table.sl-nodelock.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_nodelock</TT
></A
></DT
><DT
>8.15. <A
HREF="table.sl-path.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_path</TT
></A
></DT
><DT
>8.16. <A
HREF="table.sl-registry.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_registry</TT
></A
></DT
><DT
>8.17. <A
HREF="view.sl-seqlastvalue.html"
>View:
         
         <TT
CLASS="STRUCTNAME"
>sl_seqlastvalue</TT
></A
></DT
><DT
>8.18. <A
HREF="table.sl-seqlog.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_seqlog</TT
></A
></DT
><DT
>8.19. <A
HREF="table.sl-sequence.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_sequence</TT
></A
></DT
><DT
>8.20. <A
HREF="table.sl-set.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_set</TT
></A
></DT
><DT
>8.21. <A
HREF="table.sl-setsync.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_setsync</TT
></A
></DT
><DT
>8.22. <A
HREF="table.sl-subscribe.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_subscribe</TT
></A
></DT
><DT
>8.23. <A
HREF="table.sl-table.html"
>Table:
         
         <TT
CLASS="STRUCTNAME"
>sl_table</TT
></A
></DT
><DT
>8.24. <A
HREF="function.add-empty-table-to-replication-p-comment-integer-p-idxname-integer-p-tabname-text-p-nspname-text-p-tab-id-text-p-set-id-text.html"
>add_empty_table_to_replication(p_comment integer, p_idxname integer, p_tabname text, p_nspname text, p_tab_id text, p_set_id text)</A
></DT
><DT
>8.25. <A
HREF="function.add-missing-table-field-p-type-text-p-field-text-p-table-text-p-namespace-text.html"
>add_missing_table_field(p_type text, p_field text, p_table text, p_namespace text)</A
></DT
><DT
>8.26. <A
HREF="function.addpartiallogindices.html"
>addpartiallogindices()</A
></DT
><DT
>8.27. <A
HREF="function.agg-text-sum-txt-new-text-txt-before-text.html"
>agg_text_sum(txt_new text, txt_before text)</A
></DT
><DT
>8.28. <A
HREF="function.altertableaddtriggers-p-tab-id-integer.html"
>altertableaddtriggers(p_tab_id integer)</A
></DT
><DT
>8.29. <A
HREF="function.altertableconfiguretriggers-p-tab-id-integer.html"
>altertableconfiguretriggers(p_tab_id integer)</A
></DT
><DT
>8.30. <A
HREF="function.altertabledroptriggers-p-tab-id-integer.html"
>altertabledroptriggers(p_tab_id integer)</A
></DT
><DT
>8.31. <A
HREF="function.check-table-field-exists-p-field-text-p-table-text-p-namespace-text.html"
>check_table_field_exists(p_field text, p_table text, p_namespace text)</A
></DT
><DT
>8.32. <A
HREF="function.check-unconfirmed-log.html"
>check_unconfirmed_log()</A
></DT
><DT
>8.33. <A
HREF="function.checkmoduleversion.html"
>checkmoduleversion()</A
></DT
><DT
>8.34. <A
HREF="function.cleanupevent-p-interval-interval.html"
>cleanupevent(p_interval interval)</A
></DT
><DT
>8.35. <A
HREF="function.cleanupnodelock.html"
>cleanupnodelock()</A
></DT
><DT
>8.36. <A
HREF="function.clonenodefinish-p-no-provider-integer-p-no-id-integer.html"
>clonenodefinish(p_no_provider integer, p_no_id integer)</A
></DT
><DT
>8.37. <A
HREF="function.clonenodeprepare-p-no-comment-integer-p-no-provider-integer-p-no-id-text.html"
>clonenodeprepare(p_no_comment integer, p_no_provider integer, p_no_id text)</A
></DT
><DT
>8.38. <A
HREF="function.clonenodeprepare-int-p-no-comment-integer-p-no-provider-integer-p-no-id-text.html"
>clonenodeprepare_int(p_no_comment integer, p_no_provider integer, p_no_id text)</A
></DT
><DT
>8.39. <A
HREF="function.component-state-i-eventtype-text-i-event-integer-i-starttime-integer-i-activity-integer-i-conn-pid-text-i-node-timestamp-with-time-zone-i-pid-bigint-i-actor-text.html"
>component_state(i_eventtype text, i_event integer, i_starttime integer, i_activity integer, i_conn_pid text, i_node timestamp with time zone, i_pid bigint, i_actor text)</A
></DT
><DT
>8.40. <A
HREF="function.copyfields-p-tab-id-integer.html"
>copyfields(p_tab_id integer)</A
></DT
><DT
>8.41. <A
HREF="function.ddlcapture-p-nodes-text-p-statement-text.html"
>ddlcapture(p_nodes text, p_statement text)</A
></DT
><DT
>8.42. <A
HREF="function.ddlscript-complete-p-nodes-text.html"
>ddlscript_complete(p_nodes text)</A
></DT
><DT
>8.43. <A
HREF="function.ddlscript-complete-int.html"
>ddlscript_complete_int()</A
></DT
><DT
>8.44. <A
HREF="function.deny-truncate.html"
>deny_truncate()</A
></DT
><DT
>8.45. <A
HREF="function.determineattkindunique-p-idx-name-text-p-tab-fqname-name.html"
>determineattkindunique(p_idx_name text, p_tab_fqname name)</A
></DT
><DT
>8.46. <A
HREF="function.determineidxnameunique-p-idx-name-text-p-tab-fqname-name.html"
>determineidxnameunique(p_idx_name text, p_tab_fqname name)</A
></DT
><DT
>8.47. <A
HREF="function.disable-indexes-on-table-i-oid-oid.html"
>disable_indexes_on_table(i_oid oid)</A
></DT
><DT
>8.48. <A
HREF="function.disablenode-p-no-id-integer.html"
>disablenode(p_no_id integer)</A
></DT
><DT
>8.49. <A
HREF="function.disablenode-int-p-no-id-integer.html"
>disablenode_int(p_no_id integer)</A
></DT
><DT
>8.50. <A
HREF="function.droplisten-p-li-receiver-integer-p-li-provider-integer-p-li-origin-integer.html"
>droplisten(p_li_receiver integer, p_li_provider integer, p_li_origin integer)</A
></DT
><DT
>8.51. <A
HREF="function.droplisten-int-p-li-receiver-integer-p-li-provider-integer-p-li-origin-integer.html"
>droplisten_int(p_li_receiver integer, p_li_provider integer, p_li_origin integer)</A
></DT
><DT
>8.52. <A
HREF="function.dropnode-p-no-ids-integerarray.html"
>dropnode(p_no_ids integer[])</A
></DT
><DT
>8.53. <A
HREF="function.dropnode-int-p-no-id-integer.html"
>dropnode_int(p_no_id integer)</A
></DT
><DT
>8.54. <A
HREF="function.droppath-p-pa-client-integer-p-pa-server-integer.html"
>droppath(p_pa_client integer, p_pa_server integer)</A
></DT
><DT
>8.55. <A
HREF="function.droppath-int-p-pa-client-integer-p-pa-server-integer.html"
>droppath_int(p_pa_client integer, p_pa_server integer)</A
></DT
><DT
>8.56. <A
HREF="function.dropset-p-set-id-integer.html"
>dropset(p_set_id integer)</A
></DT
><DT
>8.57. <A
HREF="function.dropset-int-p-set-id-integer.html"
>dropset_int(p_set_id integer)</A
></DT
><DT
>8.58. <A
HREF="function.enable-indexes-on-table-i-oid-oid.html"
>enable_indexes_on_table(i_oid oid)</A
></DT
><DT
>8.59. <A
HREF="function.enablenode-p-no-id-integer.html"
>enablenode(p_no_id integer)</A
></DT
><DT
>8.60. <A
HREF="function.enablenode-int-p-no-id-integer.html"
>enablenode_int(p_no_id integer)</A
></DT
><DT
>8.61. <A
HREF="function.enablesubscription-p-sub-receiver-integer-p-sub-provider-integer-p-sub-set-integer.html"
>enablesubscription(p_sub_receiver integer, p_sub_provider integer, p_sub_set integer)</A
></DT
><DT
>8.62. <A
HREF="function.enablesubscription-int-p-sub-receiver-integer-p-sub-provider-integer-p-sub-set-integer.html"
>enablesubscription_int(p_sub_receiver integer, p_sub_provider integer, p_sub_set integer)</A
></DT
><DT
>8.63. <A
HREF="function.failednode-p-failed-nodes-integer-p-backup-node-integer-p-failed-node-integerarray.html"
>failednode(p_failed_nodes integer, p_backup_node integer, p_failed_node integer[])</A
></DT
><DT
>8.64. <A
HREF="function.failednode2-p-failed-nodes-integer-p-ev-seqno-integer-p-backup-node-bigint-p-failed-node-integerarray.html"
>failednode2(p_failed_nodes integer, p_ev_seqno integer, p_backup_node bigint, p_failed_node integer[])</A
></DT
><DT
>8.65. <A
HREF="function.failednode3-p-seq-no-integer-p-backup-node-integer-p-failed-node-bigint.html"
>failednode3(p_seq_no integer, p_backup_node integer, p_failed_node bigint)</A
></DT
><DT
>8.66. <A
HREF="function.failoverset-int-p-last-seqno-integer-p-backup-node-integer-p-failed-node-bigint.html"
>failoverset_int(p_last_seqno integer, p_backup_node integer, p_failed_node bigint)</A
></DT
><DT
>8.67. <A
HREF="function.finishtableaftercopy-p-tab-id-integer.html"
>finishtableaftercopy(p_tab_id integer)</A
></DT
><DT
>8.68. <A
HREF="function.forwardconfirm-p-con-timestamp-integer-p-con-seqno-integer-p-con-received-bigint-p-con-origin-timestamp-without-time-zone.html"
>forwardconfirm(p_con_timestamp integer, p_con_seqno integer, p_con_received bigint, p_con_origin timestamp without time zone)</A
></DT
><DT
>8.69. <A
HREF="function.generate-sync-event-p-interval-interval.html"
>generate_sync_event(p_interval interval)</A
></DT
><DT
>8.70. <A
HREF="function.initializelocalnode-p-comment-integer-p-local-node-id-text.html"
>initializelocalnode(p_comment integer, p_local_node_id text)</A
></DT
><DT
>8.71. <A
HREF="function.is-node-reachable-receiver-node-id-integer-origin-node-id-integer.html"
>is_node_reachable(receiver_node_id integer, origin_node_id integer)</A
></DT
><DT
>8.72. <A
HREF="function.issubscriptioninprogress-p-add-id-integer.html"
>issubscriptioninprogress(p_add_id integer)</A
></DT
><DT
>8.73. <A
HREF="function.lockset-p-set-id-integer.html"
>lockset(p_set_id integer)</A
></DT
><DT
>8.74. <A
HREF="function.log-truncate.html"
>log_truncate()</A
></DT
><DT
>8.75. <A
HREF="function.logswitch-finish.html"
>logswitch_finish()</A
></DT
><DT
>8.76. <A
HREF="function.logswitch-start.html"
>logswitch_start()</A
></DT
><DT
>8.77. <A
HREF="function.mergeset-p-add-id-integer-p-set-id-integer.html"
>mergeset(p_add_id integer, p_set_id integer)</A
></DT
><DT
>8.78. <A
HREF="function.mergeset-int-p-add-id-integer-p-set-id-integer.html"
>mergeset_int(p_add_id integer, p_set_id integer)</A
></DT
><DT
>8.79. <A
HREF="function.moveset-p-new-origin-integer-p-set-id-integer.html"
>moveset(p_new_origin integer, p_set_id integer)</A
></DT
><DT
>8.80. <A
HREF="function.moveset-int-p-wait-seqno-integer-p-new-origin-integer-p-old-origin-integer-p-set-id-bigint.html"
>moveset_int(p_wait_seqno integer, p_new_origin integer, p_old_origin integer, p_set_id bigint)</A
></DT
><DT
>8.81. <A
HREF="function.prefailover-p-is-candidate-integer-p-failed-node-boolean.html"
>prefailover(p_is_candidate integer, p_failed_node boolean)</A
></DT
><DT
>8.82. <A
HREF="function.preparetableforcopy-p-tab-id-integer.html"
>preparetableforcopy(p_tab_id integer)</A
></DT
><DT
>8.83. <A
HREF="function.rebuildlistenentries.html"
>rebuildlistenentries()</A
></DT
><DT
>8.84. <A
HREF="function.recreate-log-trigger-p-tab-attkind-text-p-tab-id-oid-p-fq-table-name-text.html"
>recreate_log_trigger(p_tab_attkind text, p_tab_id oid, p_fq_table_name text)</A
></DT
><DT
>8.85. <A
HREF="function.registernodeconnection-p-nodeid-integer.html"
>registernodeconnection(p_nodeid integer)</A
></DT
><DT
>8.86. <A
HREF="function.registry-get-int4-p-default-text-p-key-integer.html"
>registry_get_int4(p_default text, p_key integer)</A
></DT
><DT
>8.87. <A
HREF="function.registry-get-text-p-default-text-p-key-text.html"
>registry_get_text(p_default text, p_key text)</A
></DT
><DT
>8.88. <A
HREF="function.registry-get-timestamp-p-default-text-p-key-timestamp-with-time-zone.html"
>registry_get_timestamp(p_default text, p_key timestamp with time zone)</A
></DT
><DT
>8.89. <A
HREF="function.registry-set-int4-p-value-text-p-key-integer.html"
>registry_set_int4(p_value text, p_key integer)</A
></DT
><DT
>8.90. <A
HREF="function.registry-set-text-p-value-text-p-key-text.html"
>registry_set_text(p_value text, p_key text)</A
></DT
><DT
>8.91. <A
HREF="function.registry-set-timestamp-p-value-text-p-key-timestamp-with-time-zone.html"
>registry_set_timestamp(p_value text, p_key timestamp with time zone)</A
></DT
><DT
>8.92. <A
HREF="function.repair-log-triggers-only-locked-boolean.html"
>repair_log_triggers(only_locked boolean)</A
></DT
><DT
>8.93. <A
HREF="function.replicate-partition-p-comment-integer-p-idxname-text-p-tabname-text-p-nspname-text-p-tab-id-text.html"
>replicate_partition(p_comment integer, p_idxname text, p_tabname text, p_nspname text, p_tab_id text)</A
></DT
><DT
>8.94. <A
HREF="function.reshapesubscription-p-sub-receiver-integer-p-sub-provider-integer-p-sub-origin-integer.html"
>reshapesubscription(p_sub_receiver integer, p_sub_provider integer, p_sub_origin integer)</A
></DT
><DT
>8.95. <A
HREF="function.resubscribenode-p-receiver-integer-p-provider-integer-p-origin-integer.html"
>resubscribenode(p_receiver integer, p_provider integer, p_origin integer)</A
></DT
><DT
>8.96. <A
HREF="function.sequencelastvalue-p-seqname-text.html"
>sequencelastvalue(p_seqname text)</A
></DT
><DT
>8.97. <A
HREF="function.sequencesetvalue-p-ignore-missing-integer-p-last-value-integer-p-ev-seqno-bigint-p-seq-origin-bigint-p-seq-id-boolean.html"
>sequencesetvalue(p_ignore_missing integer, p_last_value integer, p_ev_seqno bigint, p_seq_origin bigint, p_seq_id boolean)</A
></DT
><DT
>8.98. <A
HREF="function.setaddsequence-p-seq-comment-integer-p-fqname-integer-p-seq-id-text-p-set-id-text.html"
>setaddsequence(p_seq_comment integer, p_fqname integer, p_seq_id text, p_set_id text)</A
></DT
><DT
>8.99. <A
HREF="function.setaddsequence-int-p-seq-comment-integer-p-fqname-integer-p-seq-id-text-p-set-id-text.html"
>setaddsequence_int(p_seq_comment integer, p_fqname integer, p_seq_id text, p_set_id text)</A
></DT
><DT
>8.100. <A
HREF="function.setaddtable-p-tab-comment-integer-p-tab-idxname-integer-p-fqname-text-p-tab-id-name-p-set-id-text.html"
>setaddtable(p_tab_comment integer, p_tab_idxname integer, p_fqname text, p_tab_id name, p_set_id text)</A
></DT
><DT
>8.101. <A
HREF="function.setaddtable-int-p-tab-comment-integer-p-tab-idxname-integer-p-fqname-text-p-tab-id-name-p-set-id-text.html"
>setaddtable_int(p_tab_comment integer, p_tab_idxname integer, p_fqname text, p_tab_id name, p_set_id text)</A
></DT
><DT
>8.102. <A
HREF="function.setdropsequence-p-seq-id-integer.html"
>setdropsequence(p_seq_id integer)</A
></DT
><DT
>8.103. <A
HREF="function.setdropsequence-int-p-seq-id-integer.html"
>setdropsequence_int(p_seq_id integer)</A
></DT
><DT
>8.104. <A
HREF="function.setdroptable-p-tab-id-integer.html"
>setdroptable(p_tab_id integer)</A
></DT
><DT
>8.105. <A
HREF="function.setdroptable-int-p-tab-id-integer.html"
>setdroptable_int(p_tab_id integer)</A
></DT
><DT
>8.106. <A
HREF="function.setmovesequence-p-new-set-id-integer-p-seq-id-integer.html"
>setmovesequence(p_new_set_id integer, p_seq_id integer)</A
></DT
><DT
>8.107. <A
HREF="function.setmovesequence-int-p-new-set-id-integer-p-seq-id-integer.html"
>setmovesequence_int(p_new_set_id integer, p_seq_id integer)</A
></DT
><DT
>8.108. <A
HREF="function.setmovetable-p-new-set-id-integer-p-tab-id-integer.html"
>setmovetable(p_new_set_id integer, p_tab_id integer)</A
></DT
><DT
>8.109. <A
HREF="function.setmovetable-int-p-new-set-id-integer-p-tab-id-integer.html"
>setmovetable_int(p_new_set_id integer, p_tab_id integer)</A
></DT
><DT
>8.110. <A
HREF="function.slon-node-health-check.html"
>slon_node_health_check()</A
></DT
><DT
>8.111. <A
HREF="function.slon-quote-brute-p-tab-fqname-text.html"
>slon_quote_brute(p_tab_fqname text)</A
></DT
><DT
>8.112. <A
HREF="function.slon-quote-input-p-tab-fqname-text.html"
>slon_quote_input(p_tab_fqname text)</A
></DT
><DT
>8.113. <A
HREF="function.slonyversion.html"
>slonyversion()</A
></DT
><DT
>8.114. <A
HREF="function.slonyversionmajor.html"
>slonyversionmajor()</A
></DT
><DT
>8.115. <A
HREF="function.slonyversionminor.html"
>slonyversionminor()</A
></DT
><DT
>8.116. <A
HREF="function.slonyversionpatchlevel.html"
>slonyversionpatchlevel()</A
></DT
><DT
>8.117. <A
HREF="function.store-application-name-i-name-text.html"
>store_application_name(i_name text)</A
></DT
><DT
>8.118. <A
HREF="function.storelisten-p-receiver-integer-p-provider-integer-p-origin-integer.html"
>storelisten(p_receiver integer, p_provider integer, p_origin integer)</A
></DT
><DT
>8.119. <A
HREF="function.storelisten-int-p-li-receiver-integer-p-li-provider-integer-p-li-origin-integer.html"
>storelisten_int(p_li_receiver integer, p_li_provider integer, p_li_origin integer)</A
></DT
><DT
>8.120. <A
HREF="function.storenode-p-no-comment-integer-p-no-id-text.html"
>storenode(p_no_comment integer, p_no_id text)</A
></DT
><DT
>8.121. <A
HREF="function.storenode-int-p-no-comment-integer-p-no-id-text.html"
>storenode_int(p_no_comment integer, p_no_id text)</A
></DT
><DT
>8.122. <A
HREF="function.storepath-p-pa-connretry-integer-p-pa-conninfo-integer-p-pa-client-text-p-pa-server-integer.html"
>storepath(p_pa_connretry integer, p_pa_conninfo integer, p_pa_client text, p_pa_server integer)</A
></DT
><DT
>8.123. <A
HREF="function.storepath-int-p-pa-connretry-integer-p-pa-conninfo-integer-p-pa-client-text-p-pa-server-integer.html"
>storepath_int(p_pa_connretry integer, p_pa_conninfo integer, p_pa_client text, p_pa_server integer)</A
></DT
><DT
>8.124. <A
HREF="function.storeset-p-set-comment-integer-p-set-id-text.html"
>storeset(p_set_comment integer, p_set_id text)</A
></DT
><DT
>8.125. <A
HREF="function.storeset-int-p-set-comment-integer-p-set-origin-integer-p-set-id-text.html"
>storeset_int(p_set_comment integer, p_set_origin integer, p_set_id text)</A
></DT
><DT
>8.126. <A
HREF="function.string-agg-text.html"
>string_agg(text)</A
></DT
><DT
>8.127. <A
HREF="function.subscribeset-p-omit-copy-integer-p-sub-forward-integer-p-sub-receiver-integer-p-sub-provider-boolean-p-sub-set-boolean.html"
>subscribeset(p_omit_copy integer, p_sub_forward integer, p_sub_receiver integer, p_sub_provider boolean, p_sub_set boolean)</A
></DT
><DT
>8.128. <A
HREF="function.subscribeset-int-p-omit-copy-integer-p-sub-forward-integer-p-sub-receiver-integer-p-sub-provider-boolean-p-sub-set-boolean.html"
>subscribeset_int(p_omit_copy integer, p_sub_forward integer, p_sub_receiver integer, p_sub_provider boolean, p_sub_set boolean)</A
></DT
><DT
>8.129. <A
HREF="function.tablestovacuum.html"
>tablestovacuum()</A
></DT
><DT
>8.130. <A
HREF="function.terminatenodeconnections-p-failed-node-integer.html"
>terminatenodeconnections(p_failed_node integer)</A
></DT
><DT
>8.131. <A
HREF="function.uninstallnode.html"
>uninstallnode()</A
></DT
><DT
>8.132. <A
HREF="function.unlockset-p-set-id-integer.html"
>unlockset(p_set_id integer)</A
></DT
><DT
>8.133. <A
HREF="function.unsubscribe-abandoned-sets-p-failed-node-integer.html"
>unsubscribe_abandoned_sets(p_failed_node integer)</A
></DT
><DT
>8.134. <A
HREF="function.unsubscribeset-p-force-integer-p-sub-receiver-integer-p-sub-set-boolean.html"
>unsubscribeset(p_force integer, p_sub_receiver integer, p_sub_set boolean)</A
></DT
><DT
>8.135. <A
HREF="function.unsubscribeset-int-p-sub-receiver-integer-p-sub-set-integer.html"
>unsubscribeset_int(p_sub_receiver integer, p_sub_set integer)</A
></DT
><DT
>8.136. <A
HREF="function.updaterelname.html"
>updaterelname()</A
></DT
><DT
>8.137. <A
HREF="function.updatereloid-p-only-on-node-integer-p-set-id-integer.html"
>updatereloid(p_only_on_node integer, p_set_id integer)</A
></DT
><DT
>8.138. <A
HREF="function.upgradeschema-p-old-text.html"
>upgradeschema(p_old text)</A
></DT
></DL
></DD
><DT
><A
HREF="bookindex.html"
>Index</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Tables</B
></DT
><DT
>4-1. <A
HREF="triggers.html#TRIGGERBEHAVIOUR"
>Trigger Behaviour</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Figures</B
></DT
><DT
>8-1. <A
HREF="view.sl-failover-targets.html#AEN10637"
>Definition of view sl_failover_targets</A
></DT
><DT
>8-2. <A
HREF="view.sl-seqlastvalue.html#AEN11086"
>Definition of view sl_seqlastvalue</A
></DT
></DL
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="preface.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Preface</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
slony1-2-doc 2.2.4-3 / usr / share / doc / slony1-2-doc / adminguide / index.html
