pgpool2.git / summary / log / commit / refs

commit    7cdccdde0f1847abc8d09080115905ce5c15bff9
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Fri Oct 21 03:32:45 2016 +0000

    Translate restrictions.sgml into Japanese.
    
    Fix errors in restrictions.sgml (English).


doc.ja/src/sgml/HTML.index | 1262 ------------------------------------- doc.ja/src/sgml/bookindex.sgml | 1135 --------------------------------- doc.ja/src/sgml/restrictions.sgml | 199 +++++- doc/src/sgml/restrictions.sgml | 72 ++- 4 files changed, 212 insertions(+), 2456 deletions(-) diff --git a/doc.ja/src/sgml/HTML.index b/doc.ja/src/sgml/HTML.index deleted file mode 100644 index a452b8193..000000000 --- a/doc.ja/src/sgml/HTML.index +++ /dev/null @@ -1,1262 +0,0 @@ -INDEXTERM history.html -INDEXPOINT history.html#AEN100 -TITLE Pgpool-IIの歴史概要 -significance NORMAL -ZONE history.html -TITLE Pgpool-IIの歴史概要 -PRIMARY 歴史 -SECONDARY Pgpool-IIの -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-COORDINATING-NODES -INDEXPOINT tutorial-watchdog-intro.html#AEN364 -TITLE Coordinating multiple Pgpool-II nodes -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-COORDINATING-NODES -TITLE Coordinating multiple Pgpool-II nodes -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-LIFECHECKING -INDEXPOINT tutorial-watchdog-intro.html#AEN378 -TITLE Life checking of other Pgpool-II nodes -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-LIFECHECKING -TITLE Life checking of other Pgpool-II nodes -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CONSISTENCY-OF-CONFIG -INDEXPOINT tutorial-watchdog-intro.html#AEN415 -TITLE Consistency of configuration parameters on all Pgpool-II nodes -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CONSISTENCY-OF-CONFIG -TITLE Consistency of configuration parameters on all Pgpool-II nodes -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-ACTIVE -INDEXPOINT tutorial-watchdog-intro.html#AEN422 -TITLE Changing active/standby state when certain fault is detected -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-ACTIVE -TITLE Changing active/standby state when certain fault is detected -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-AUTOMATIC-VIP -INDEXPOINT tutorial-watchdog-intro.html#AEN430 -TITLE Automatic virtual IP switching -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-AUTOMATIC-VIP -TITLE Automatic virtual IP switching -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-AUTOMATIC-REGISTER-IN-RECOVERY -INDEXPOINT tutorial-watchdog-intro.html#AEN437 -TITLE Automatic registration of a server as a standby in recovery -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-AUTOMATIC-REGISTER-IN-RECOVERY -TITLE Automatic registration of a server as a standby in recovery -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-START-STOP -INDEXPOINT tutorial-watchdog-intro.html#AEN442 -TITLE Starting/stopping watchdog -significance NORMAL -ZONE tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-START-STOP -TITLE Starting/stopping watchdog -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET -INDEXPOINT tutorial-watchdog-integrating-external-lifecheck.html#AEN466 -TITLE Watchdog IPC command packet format -significance NORMAL -ZONE tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET -TITLE Watchdog IPC command packet format -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-RESULT-PACKET -INDEXPOINT tutorial-watchdog-integrating-external-lifecheck.html#AEN494 -TITLE Watchdog IPC result packet format -significance NORMAL -ZONE tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-RESULT-PACKET -TITLE Watchdog IPC result packet format -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET-TYPES -INDEXPOINT tutorial-watchdog-integrating-external-lifecheck.html#AEN522 -TITLE Watchdog IPC command packet types -significance NORMAL -ZONE tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET-TYPES -TITLE Watchdog IPC command packet types -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-IPC -INDEXPOINT tutorial-watchdog-integrating-external-lifecheck.html#AEN573 -TITLE External lifecheck IPC packets and data -significance NORMAL -ZONE tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-IPC -TITLE External lifecheck IPC packets and data -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-GET-NODES -INDEXPOINT tutorial-watchdog-integrating-external-lifecheck.html#AEN578 -TITLE Getting list of configured watchdog nodes -significance NORMAL -ZONE tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-GET-NODES -TITLE Getting list of configured watchdog nodes -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-restrictions.html -INDEXPOINT tutorial-watchdog-restrictions.html#AEN603 -TITLE Restrictions on watchdog -significance NORMAL -ZONE tutorial-watchdog-restrictions.html -TITLE Restrictions on watchdog -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-QUERY-MODE -INDEXPOINT tutorial-watchdog-restrictions.html#AEN607 -TITLE Watchdog restriction with query mode lifecheck -significance NORMAL -ZONE tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-QUERY-MODE -TITLE Watchdog restriction with query mode lifecheck -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-MODE -INDEXPOINT tutorial-watchdog-restrictions.html#AEN618 -TITLE Connecting to Pgpool-II whose watchdog status is down -significance NORMAL -ZONE tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-MODE -TITLE Connecting to Pgpool-II whose watchdog status is down -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-REQUIRE-RESTART -INDEXPOINT tutorial-watchdog-restrictions.html#AEN628 -TITLE Pgpool-II whose watchdog status is down requires restart -significance NORMAL -ZONE tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-REQUIRE-RESTART -TITLE Pgpool-II whose watchdog status is down requires restart -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-ACTIVE-TAKE-TIME -INDEXPOINT tutorial-watchdog-restrictions.html#AEN636 -TITLE Watchdog promotion to active takes few seconds -significance NORMAL -ZONE tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-ACTIVE-TAKE-TIME -TITLE Watchdog promotion to active takes few seconds -PRIMARY WATCHDOG -/INDEXTERM -INDEXTERM installation.html -INDEXPOINT installation.html#AEN719 -TITLE Pgpool-II Installation from Source Code -significance NORMAL -ZONE installation.html -TITLE Pgpool-II Installation from Source Code -PRIMARY installation -/INDEXTERM -INDEXTERM install-requirements.html -INDEXPOINT install-requirements.html#AEN734 -TITLE Requirements -significance NORMAL -PRIMARY make -/INDEXTERM -INDEXTERM install-requirements.html -INDEXPOINT install-requirements.html#AEN767 -TITLE Requirements -significance NORMAL -PRIMARY flex -/INDEXTERM -INDEXTERM install-requirements.html -INDEXPOINT install-requirements.html#AEN769 -TITLE Requirements -significance NORMAL -PRIMARY lex -/INDEXTERM -INDEXTERM install-requirements.html -INDEXPOINT install-requirements.html#AEN771 -TITLE Requirements -significance NORMAL -PRIMARY bison -/INDEXTERM -INDEXTERM install-requirements.html -INDEXPOINT install-requirements.html#AEN773 -TITLE Requirements -significance NORMAL -PRIMARY yacc -/INDEXTERM -INDEXTERM install-pgpool.html -INDEXPOINT install-pgpool.html#AEN819 -TITLE Installing pgpool-II -significance NORMAL -PRIMARY OpenSSL -/INDEXTERM -INDEXTERM pgpool-ii-user.html -INDEXPOINT pgpool-ii-user.html#AEN941 -TITLE The Pgpool-II User Account -significance NORMAL -PRIMARY Pgpool-II user -/INDEXTERM -INDEXTERM configuring-pcp-conf.html -INDEXPOINT configuring-pcp-conf.html#AEN952 -TITLE Configuring pcp.conf -significance NORMAL -PRIMARY pcp configuration -/INDEXTERM -INDEXTERM configuring-pgpool.html -INDEXPOINT configuring-pgpool.html#AEN971 -TITLE Configuring pgpool -significance NORMAL -PRIMARY Pgpool-II configuration -/INDEXTERM -INDEXTERM runtime-config.html -INDEXPOINT runtime-config.html#AEN1012 -TITLE Server Configuration -significance NORMAL -PRIMARY configuration -SECONDARY of the server -/INDEXTERM -INDEXTERM config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE -INDEXPOINT config-setting.html#AEN1047 -TITLE Parameter Interaction via the Configuration File -significance NORMAL -PRIMARY pgpool.conf -/INDEXTERM -INDEXTERM config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE -INDEXPOINT config-setting.html#AEN1054 -TITLE Parameter Interaction via the Configuration File -significance NORMAL -PRIMARY SIGHUP -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1079 -TITLE Connection Settings -significance NORMAL -PRIMARY listen_addresses configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1092 -TITLE Connection Settings -significance NORMAL -PRIMARY port configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1103 -TITLE Connection Settings -significance NORMAL -PRIMARY socket_dir configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1116 -TITLE Connection Settings -significance NORMAL -PRIMARY pcp_listen_addresses configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1129 -TITLE Connection Settings -significance NORMAL -PRIMARY pcp_port configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1140 -TITLE Connection Settings -significance NORMAL -PRIMARY pcp_socket_dir configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1153 -TITLE Connection Settings -significance NORMAL -PRIMARY num_init_children configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1184 -TITLE Authentication Settings -significance NORMAL -PRIMARY enable_pool_hba configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1199 -TITLE Authentication Settings -significance NORMAL -PRIMARY pool_passwd configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS -INDEXPOINT runtime-config-connection.html#AEN1211 -TITLE Authentication Settings -significance NORMAL -PRIMARY authentication_timeout configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-MASTER-SLAVE-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1236 -TITLE Master slave mode -significance NORMAL -PRIMARY master_slave_mode configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-MASTER-SLAVE-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1250 -TITLE Master slave mode -significance NORMAL -PRIMARY master_slave_sub_mode configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1288 -TITLE Replication mode -significance NORMAL -PRIMARY replication_mode configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1302 -TITLE Replication mode -significance NORMAL -PRIMARY replication_stop_on_mismatch configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1321 -TITLE Replication mode -significance NORMAL -PRIMARY failover_if_affected_tuples_mismatch configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1337 -TITLE Replication mode -significance NORMAL -PRIMARY replicate_select configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1389 -TITLE Replication mode -significance NORMAL -PRIMARY insert_lock configuration parameter -/INDEXTERM -INDEXTERM runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE -INDEXPOINT runtime-config-runnung-mode.html#AEN1442 -TITLE Replication mode -significance NORMAL -PRIMARY lobj_lock_table configuration parameter -/INDEXTERM -INDEXTERM runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS -INDEXPOINT runtime-config-backend-settings.html#AEN1493 -TITLE Backend Connection Settings -significance NORMAL -PRIMARY backend_hostname configuration parameter -/INDEXTERM -INDEXTERM runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS -INDEXPOINT runtime-config-backend-settings.html#AEN1511 -TITLE Backend Connection Settings -significance NORMAL -PRIMARY backend_port configuration parameter -/INDEXTERM -INDEXTERM runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS -INDEXPOINT runtime-config-backend-settings.html#AEN1523 -TITLE Backend Connection Settings -significance NORMAL -PRIMARY backend_weight configuration parameter -/INDEXTERM -INDEXTERM runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-DATA -INDEXPOINT runtime-config-backend-settings.html#AEN1537 -TITLE Backend Data Settings -significance NORMAL -PRIMARY backend_data_directory configuration parameter -/INDEXTERM -INDEXTERM runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-DATA -INDEXPOINT runtime-config-backend-settings.html#AEN1549 -TITLE Backend Data Settings -significance NORMAL -PRIMARY backend_flag configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1583 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY connection_cache configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1595 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY max_pool configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1609 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY listen_backlog_multiplier configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1629 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY serialize_accept configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1671 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY child_life_time configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1694 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY client_idle_limit configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1710 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY child_max_connections configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1728 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY connection_life_time configuration parameter -/INDEXTERM -INDEXTERM runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS -INDEXPOINT runtime-config-connection-pooling.html#AEN1739 -TITLE Connection Pooling Settings -significance NORMAL -PRIMARY reset_query_list configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1784 -TITLE Where To Log -significance NORMAL -PRIMARY log_destination configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1804 -TITLE Where To Log -significance NORMAL -PRIMARY syslog_facility configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1815 -TITLE Where To Log -significance NORMAL -PRIMARY syslog_ident configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1830 -TITLE When To Log -significance NORMAL -PRIMARY client_min_messages configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1840 -TITLE When To Log -significance NORMAL -PRIMARY log_min_messages configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1853 -TITLE What To Log -significance NORMAL -PRIMARY log_statement configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1863 -TITLE What To Log -significance NORMAL -PRIMARY log_per_node_statement configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1874 -TITLE What To Log -significance NORMAL -PRIMARY log_hostname configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1885 -TITLE What To Log -significance NORMAL -PRIMARY log_connections configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1895 -TITLE What To Log -significance NORMAL -PRIMARY log_error_verbosity configuration parameter -/INDEXTERM -INDEXTERM runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG -INDEXPOINT runtime-config-logging.html#AEN1905 -TITLE What To Log -significance NORMAL -PRIMARY log_line_prefix configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN1968 -TITLE Load Balancing -significance NORMAL -PRIMARY load_balance_mode configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN1980 -TITLE Load Balancing -significance NORMAL -PRIMARY ignore_leading_white_space configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN1991 -TITLE Load Balancing -significance NORMAL -PRIMARY white_function_list configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN2008 -TITLE Load Balancing -significance NORMAL -PRIMARY black_function_list configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN2051 -TITLE Load Balancing -significance NORMAL -PRIMARY database_redirect_preference_list configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN2089 -TITLE Load Balancing -significance NORMAL -PRIMARY app_name_redirect_preference_list configuration parameter -/INDEXTERM -INDEXTERM runtime-config-load-balancing.html -INDEXPOINT runtime-config-load-balancing.html#AEN2147 -TITLE Load Balancing -significance NORMAL -PRIMARY allow_sql_comments configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2171 -TITLE Health Check -significance NORMAL -PRIMARY health_check_timeout configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2182 -TITLE Health Check -significance NORMAL -PRIMARY health_check_period configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2192 -TITLE Health Check -significance NORMAL -PRIMARY health_check_user configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2202 -TITLE Health Check -significance NORMAL -PRIMARY health_check_password configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2213 -TITLE Health Check -significance NORMAL -PRIMARY health_check_database configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2230 -TITLE Health Check -significance NORMAL -PRIMARY health_check_max_retries configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2244 -TITLE Health Check -significance NORMAL -PRIMARY health_check_retry_delay configuration parameter -/INDEXTERM -INDEXTERM runtime-config-health-check.html -INDEXPOINT runtime-config-health-check.html#AEN2255 -TITLE Health Check -significance NORMAL -PRIMARY connect_timeout configuration parameter -/INDEXTERM -INDEXTERM runtime-config-failover.html -INDEXPOINT runtime-config-failover.html#AEN2271 -TITLE Failover and Failback -significance NORMAL -PRIMARY failover_command configuration parameter -/INDEXTERM -INDEXTERM runtime-config-failover.html -INDEXPOINT runtime-config-failover.html#AEN2330 -TITLE Failover and Failback -significance NORMAL -PRIMARY failback_command configuration parameter -/INDEXTERM -INDEXTERM runtime-config-failover.html -INDEXPOINT runtime-config-failover.html#AEN2383 -TITLE Failover and Failback -significance NORMAL -PRIMARY follow_master_command configuration parameter -/INDEXTERM -INDEXTERM runtime-config-failover.html -INDEXPOINT runtime-config-failover.html#AEN2443 -TITLE Failover and Failback -significance NORMAL -PRIMARY fail_over_on_backend_error configuration parameter -/INDEXTERM -INDEXTERM runtime-config-failover.html -INDEXPOINT runtime-config-failover.html#AEN2460 -TITLE Failover and Failback -significance NORMAL -PRIMARY search_primary_node_timeout configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2512 -TITLE Online Recovery -significance NORMAL -PRIMARY recovery_user configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2522 -TITLE Online Recovery -significance NORMAL -PRIMARY recovery_password configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2533 -TITLE Online Recovery -significance NORMAL -PRIMARY recovery_1st_stage_command configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2572 -TITLE Online Recovery -significance NORMAL -PRIMARY recovery_2nd_stage_command configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2611 -TITLE Online Recovery -significance NORMAL -PRIMARY recovery_timeout configuration parameter -/INDEXTERM -INDEXTERM runtime-online-recovery.html -INDEXPOINT runtime-online-recovery.html#AEN2622 -TITLE Online Recovery -significance NORMAL -PRIMARY client_idle_limit_in_recovery configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2649 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY sr_check_period configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2659 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY sr_check_user configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2674 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY sr_check_password configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2686 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY sr_check_database configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2697 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY delay_threshold configuration parameter -/INDEXTERM -INDEXTERM runtime-streaming-replication-check.html -INDEXPOINT runtime-streaming-replication-check.html#AEN2712 -TITLE Streaming Replication Check -significance NORMAL -PRIMARY log_standby_delay configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-ENABLING -INDEXPOINT runtime-in-memory-query-cache.html#AEN2756 -TITLE Enabling in memory query cache -significance NORMAL -PRIMARY memory_cache_enabled configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CHOOSE-STORAGE -INDEXPOINT runtime-in-memory-query-cache.html#AEN2769 -TITLE Choosing cache storage -significance NORMAL -PRIMARY memqcache_method configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2804 -TITLE Common configurations -significance NORMAL -PRIMARY memqcache_expire configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2818 -TITLE Common configurations -significance NORMAL -PRIMARY memqcache_auto_cache_invalidation configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2833 -TITLE Common configurations -significance NORMAL -PRIMARY memqcache_maxcache configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2851 -TITLE Common configurations -significance NORMAL -PRIMARY white_memqcache_table_list configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2870 -TITLE Common configurations -significance NORMAL -PRIMARY black_memqcache_table_list configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2886 -TITLE Common configurations -significance NORMAL -PRIMARY memqcache_oiddir configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2907 -TITLE Configurations to use shared memory -significance NORMAL -PRIMARY memqcache_total_size configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2917 -TITLE Configurations to use shared memory -significance NORMAL -PRIMARY memqcache_max_num_cache configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2930 -TITLE Configurations to use shared memory -significance NORMAL -PRIMARY memqcache_cache_block_size configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-MEMCACHED-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2949 -TITLE Configurations to use memcached -significance NORMAL -PRIMARY memqcache_memcached_host configuration parameter -/INDEXTERM -INDEXTERM runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-MEMCACHED-CONFIG -INDEXPOINT runtime-in-memory-query-cache.html#AEN2963 -TITLE Configurations to use memcached -significance NORMAL -PRIMARY memqcache_memcached_port configuration parameter -/INDEXTERM -INDEXTERM runtime-ssl.html -INDEXPOINT runtime-ssl.html#AEN2977 -TITLE Secure Sockect Layer (SSL) -significance NORMAL -PRIMARY ssl configuration parameter -/INDEXTERM -INDEXTERM runtime-ssl.html -INDEXPOINT runtime-ssl.html#AEN2998 -TITLE Secure Sockect Layer (SSL) -significance NORMAL -PRIMARY ssl_key configuration parameter -/INDEXTERM -INDEXTERM runtime-ssl.html -INDEXPOINT runtime-ssl.html#AEN3009 -TITLE Secure Sockect Layer (SSL) -significance NORMAL -PRIMARY ssl_cert configuration parameter -/INDEXTERM -INDEXTERM runtime-ssl.html -INDEXPOINT runtime-ssl.html#AEN3020 -TITLE Secure Sockect Layer (SSL) -significance NORMAL -PRIMARY ssl_ca_cert configuration parameter -/INDEXTERM -INDEXTERM runtime-ssl.html -INDEXPOINT runtime-ssl.html#AEN3034 -TITLE Secure Sockect Layer (SSL) -significance NORMAL -PRIMARY ssl_ca_cert_dir configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html -INDEXPOINT runtime-watchdog-config.html#AEN3048 -TITLE Watchdog -significance NORMAL -ZONE runtime-watchdog-config.html -TITLE Watchdog -PRIMARY configuring watchdog -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-ENABLE-WATCHDOG -INDEXPOINT runtime-watchdog-config.html#AEN3059 -TITLE Enable watchdog -significance NORMAL -PRIMARY use_watchdog configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG -INDEXPOINT runtime-watchdog-config.html#AEN3072 -TITLE Watchdog communication -significance NORMAL -PRIMARY wd_hostname configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG -INDEXPOINT runtime-watchdog-config.html#AEN3083 -TITLE Watchdog communication -significance NORMAL -PRIMARY wd_port configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG -INDEXPOINT runtime-watchdog-config.html#AEN3093 -TITLE Watchdog communication -significance NORMAL -PRIMARY wd_authkey configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-UPSTREAM-CONNECTIONS -INDEXPOINT runtime-watchdog-config.html#AEN3116 -TITLE Upstream server connection -significance NORMAL -PRIMARY trusted_servers configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-UPSTREAM-CONNECTIONS -INDEXPOINT runtime-watchdog-config.html#AEN3128 -TITLE Upstream server connection -significance NORMAL -PRIMARY ping_path configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3142 -TITLE Virtual IP control -significance NORMAL -PRIMARY delegate_IP configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3155 -TITLE Virtual IP control -significance NORMAL -PRIMARY if_cmd_path configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3167 -TITLE Virtual IP control -significance NORMAL -PRIMARY if_up_cmd configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3180 -TITLE Virtual IP control -significance NORMAL -PRIMARY if_down_cmd configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3191 -TITLE Virtual IP control -significance NORMAL -PRIMARY arping_path configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL -INDEXPOINT runtime-watchdog-config.html#AEN3203 -TITLE Virtual IP control -significance NORMAL -PRIMARY arping_cmd configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION -INDEXPOINT runtime-watchdog-config.html#AEN3221 -TITLE Behaivor on escalation and de-escalation -significance NORMAL -PRIMARY clear_memqcache_on_escalation configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION -INDEXPOINT runtime-watchdog-config.html#AEN3236 -TITLE Behaivor on escalation and de-escalation -significance NORMAL -PRIMARY wd_escalation_command configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION -INDEXPOINT runtime-watchdog-config.html#AEN3247 -TITLE Behaivor on escalation and de-escalation -significance NORMAL -PRIMARY wd_de_escalation_command configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK -INDEXPOINT runtime-watchdog-config.html#AEN3269 -TITLE Life checking Pgpool-II -significance NORMAL -PRIMARY wd_lifecheck_method configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK -INDEXPOINT runtime-watchdog-config.html#AEN3302 -TITLE Life checking Pgpool-II -significance NORMAL -PRIMARY wd_monitoring_interfaces_list configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK -INDEXPOINT runtime-watchdog-config.html#AEN3320 -TITLE Life checking Pgpool-II -significance NORMAL -PRIMARY wd_interval configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK -INDEXPOINT runtime-watchdog-config.html#AEN3331 -TITLE Life checking Pgpool-II -significance NORMAL -PRIMARY wd_priority configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK -INDEXPOINT runtime-watchdog-config.html#AEN3346 -TITLE Life checking Pgpool-II -significance NORMAL -PRIMARY wd_ipc_socket_dir configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3368 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY wd_heartbeat_port configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3382 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY wd_heartbeat_keepalive configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3395 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY wd_heartbeat_deadtime configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3409 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY heartbeat_destination configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3426 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY heartbeat_destination_port configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT -INDEXPOINT runtime-watchdog-config.html#AEN3441 -TITLE Lifecheck Heartbeat mode configuration -significance NORMAL -PRIMARY heartbeat_device configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY -INDEXPOINT runtime-watchdog-config.html#AEN3458 -TITLE Lifecheck Query mode configuration -significance NORMAL -PRIMARY wd_life_point configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY -INDEXPOINT runtime-watchdog-config.html#AEN3472 -TITLE Lifecheck Query mode configuration -significance NORMAL -PRIMARY wd_lifecheck_query configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY -INDEXPOINT runtime-watchdog-config.html#AEN3488 -TITLE Lifecheck Query mode configuration -significance NORMAL -PRIMARY wd_lifecheck_dbname configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY -INDEXPOINT runtime-watchdog-config.html#AEN3504 -TITLE Lifecheck Query mode configuration -significance NORMAL -PRIMARY wd_lifecheck_user configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY -INDEXPOINT runtime-watchdog-config.html#AEN3520 -TITLE Lifecheck Query mode configuration -significance NORMAL -PRIMARY wd_lifecheck_password configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION -INDEXPOINT runtime-watchdog-config.html#AEN3539 -TITLE Watchdog servers configurations -significance NORMAL -PRIMARY other_pgpool_hostname configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION -INDEXPOINT runtime-watchdog-config.html#AEN3550 -TITLE Watchdog servers configurations -significance NORMAL -PRIMARY other_pgpool_port configuration parameter -/INDEXTERM -INDEXTERM runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION -INDEXPOINT runtime-watchdog-config.html#AEN3561 -TITLE Watchdog servers configurations -significance NORMAL -PRIMARY other_wd_port0 configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3575 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY relcache_expire configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3589 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY relcache_size configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3604 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY check_temp_table configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3617 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY check_unlogged_table configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3630 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY pid_file_name configuration parameter -/INDEXTERM -INDEXTERM runtime-misc.html -INDEXPOINT runtime-misc.html#AEN3642 -TITLE Misc Configuration Parameters -significance NORMAL -PRIMARY logdir configuration parameter -/INDEXTERM -INDEXTERM client-authentication.html -INDEXPOINT client-authentication.html#AEN3652 -TITLE Client Authentication -significance NORMAL -ZONE client-authentication.html -TITLE Client Authentication -PRIMARY client authentication -/INDEXTERM -INDEXTERM auth-pool-hba-conf.html -INDEXPOINT auth-pool-hba-conf.html#AEN3667 -TITLE The pool_hba.conf File -significance NORMAL -ZONE auth-pool-hba-conf.html -TITLE The pool_hba.conf File -PRIMARY pool_hba.conf -/INDEXTERM -INDEXTERM auth-methods.html#AUTH-MD5 -INDEXPOINT auth-methods.html#AEN3834 -TITLE MD5 Password Authentication -significance NORMAL -PRIMARY MD5 -/INDEXTERM -INDEXTERM auth-methods.html#SETTING-MD5-AUTHENTICATION -INDEXPOINT auth-methods.html#AEN3848 -TITLE Setting md5 Authentication -significance NORMAL -ZONE auth-methods.html#SETTING-MD5-AUTHENTICATION -TITLE Setting md5 Authentication -PRIMARY MD5 -/INDEXTERM -INDEXTERM auth-methods.html#AUTH-PAM -INDEXPOINT auth-methods.html#AEN3863 -TITLE PAM Authentication -significance NORMAL -ZONE auth-methods.html#AUTH-PAM -TITLE PAM Authentication -PRIMARY PAM -/INDEXTERM -INDEXTERM pcp-common-options.html -INDEXPOINT pcp-common-options.html#AEN4202 -TITLE pcp_common_options -significance NORMAL -ZONE pcp-common-options.html -TITLE pcp_common_options -PRIMARY pcp_common_options -/INDEXTERM -INDEXTERM pcp-node-count.html -INDEXPOINT pcp-node-count.html#AEN4302 -TITLE pcp_node_count -significance NORMAL -ZONE pcp-node-count.html -TITLE pcp_node_count -PRIMARY pcp_node_count -/INDEXTERM -INDEXTERM pcp-node-info.html -INDEXPOINT pcp-node-info.html#AEN4330 -TITLE pcp_node_info -significance NORMAL -ZONE pcp-node-info.html -TITLE pcp_node_info -PRIMARY pcp_node_info -/INDEXTERM -INDEXTERM pcp-watchdog-info.html -INDEXPOINT pcp-watchdog-info.html#AEN4390 -TITLE pcp_watchdog_info -significance NORMAL -ZONE pcp-watchdog-info.html -TITLE pcp_watchdog_info -PRIMARY pcp_watchdog_info -/INDEXTERM -INDEXTERM pcp-proc-count.html -INDEXPOINT pcp-proc-count.html#AEN4442 -TITLE pcp_proc_count -significance NORMAL -ZONE pcp-proc-count.html -TITLE pcp_proc_count -PRIMARY pcp_proc_count -/INDEXTERM -INDEXTERM pcp-proc-info.html -INDEXPOINT pcp-proc-info.html#AEN4465 -TITLE pcp_proc_info -significance NORMAL -ZONE pcp-proc-info.html -TITLE pcp_proc_info -PRIMARY pcp_proc_info -/INDEXTERM -INDEXTERM pcp-pool-status.html -INDEXPOINT pcp-pool-status.html#AEN4515 -TITLE pcp_pool_status -significance NORMAL -ZONE pcp-pool-status.html -TITLE pcp_pool_status -PRIMARY pcp_pool_status -/INDEXTERM -INDEXTERM pcp-detach-node.html -INDEXPOINT pcp-detach-node.html#AEN4544 -TITLE pcp_detach_node -significance NORMAL -ZONE pcp-detach-node.html -TITLE pcp_detach_node -PRIMARY pcp_detach_node -/INDEXTERM -INDEXTERM pcp-attach-node.html -INDEXPOINT pcp-attach-node.html#AEN4593 -TITLE pcp_attach_node -significance NORMAL -ZONE pcp-attach-node.html -TITLE pcp_attach_node -PRIMARY pcp_attach_node -/INDEXTERM -INDEXTERM pcp-promote-node.html -INDEXPOINT pcp-promote-node.html#AEN4633 -TITLE pcp_promote_node -significance NORMAL -ZONE pcp-promote-node.html -TITLE pcp_promote_node -PRIMARY pcp_promote_node -/INDEXTERM -INDEXTERM pcp-stop-pgpool.html -INDEXPOINT pcp-stop-pgpool.html#AEN4682 -TITLE pcp_stop_pgpool -significance NORMAL -ZONE pcp-stop-pgpool.html -TITLE pcp_stop_pgpool -PRIMARY pcp_stop_pgpool -/INDEXTERM -INDEXTERM pcp-recovery-node.html -INDEXPOINT pcp-recovery-node.html#AEN4730 -TITLE pcp_recovery_node -significance NORMAL -ZONE pcp-recovery-node.html -TITLE pcp_recovery_node -PRIMARY pcp_recovery_node -/INDEXTERM -INDEXTERM pg-md5.html -INDEXPOINT pg-md5.html#AEN4774 -TITLE pg_md5 -significance NORMAL -ZONE pg-md5.html -TITLE pg_md5 -PRIMARY pg_md5 -/INDEXTERM -INDEXTERM pgpool-setup.html -INDEXPOINT pgpool-setup.html#AEN4831 -TITLE pgpool_setup -significance NORMAL -ZONE pgpool-setup.html -TITLE pgpool_setup -PRIMARY pgpool_setup -/INDEXTERM -INDEXTERM watchdog-setup.html -INDEXPOINT watchdog-setup.html#AEN4947 -TITLE watchdog_setup -significance NORMAL -ZONE watchdog-setup.html -TITLE watchdog_setup -PRIMARY watchdog_setup -/INDEXTERM -INDEXTERM sql-pgpool-show.html -INDEXPOINT sql-pgpool-show.html#AEN5075 -TITLE PGPOOL SHOW -significance NORMAL -ZONE sql-pgpool-show.html -TITLE PGPOOL SHOW -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-pgpool-set.html -INDEXPOINT sql-pgpool-set.html#AEN5151 -TITLE PGPOOL SET -significance NORMAL -ZONE sql-pgpool-set.html -TITLE PGPOOL SET -PRIMARY SET -/INDEXTERM -INDEXTERM sql-pgpool-reset.html -INDEXPOINT sql-pgpool-reset.html#AEN5191 -TITLE PGPOOL RESET -significance NORMAL -ZONE sql-pgpool-reset.html -TITLE PGPOOL RESET -PRIMARY RESET -/INDEXTERM -INDEXTERM sql-show-pgpool-status.html -INDEXPOINT sql-show-pgpool-status.html#AEN5242 -TITLE SHOW PGPOOL STATUS -significance NORMAL -ZONE sql-show-pgpool-status.html -TITLE SHOW PGPOOL STATUS -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-show-pool-nodes.html -INDEXPOINT sql-show-pool-nodes.html#AEN5267 -TITLE SHOW POOL NODES -significance NORMAL -ZONE sql-show-pool-nodes.html -TITLE SHOW POOL NODES -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-show-pool-processes.html -INDEXPOINT sql-show-pool-processes.html#AEN5289 -TITLE SHOW POOL_PROCESSES -significance NORMAL -ZONE sql-show-pool-processes.html -TITLE SHOW POOL_PROCESSES -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-show-pool-pools.html -INDEXPOINT sql-show-pool-pools.html#AEN5330 -TITLE SHOW POOL_POOLS -significance NORMAL -ZONE sql-show-pool-pools.html -TITLE SHOW POOL_POOLS -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-show-pool-version.html -INDEXPOINT sql-show-pool-version.html#AEN5390 -TITLE SHOW POOL_VERSION -significance NORMAL -ZONE sql-show-pool-version.html -TITLE SHOW POOL_VERSION -PRIMARY SHOW -/INDEXTERM -INDEXTERM sql-show-pool-cache.html -INDEXPOINT sql-show-pool-cache.html#AEN5409 -TITLE SHOW POOL_CACHE -significance NORMAL -ZONE sql-show-pool-cache.html -TITLE SHOW POOL_CACHE -PRIMARY SHOW -/INDEXTERM diff --git a/doc.ja/src/sgml/bookindex.sgml b/doc.ja/src/sgml/bookindex.sgml deleted file mode 100644 index 31643770a..000000000 --- a/doc.ja/src/sgml/bookindex.sgml +++ /dev/null @@ -1,1135 +0,0 @@ -<index id='bookindex'> - -<!-- This file was produced by collateindex.pl. --> -<!-- Remove this comment if you edit this file by hand! --> -<!-- ULINK is abused here. - - The URL attribute holds the URL that points from the index entry - back to the appropriate place in the output produced by the HTML - stylesheet. (It's much easier to calculate this URL in the first - pass.) - - The Role attribute holds the ID (either real or manufactured) of - the corresponding INDEXTERM. This is used by the print backends - to produce page numbers. - - The entries below are sorted and collated into the correct order. - Duplicates may be removed in the HTML backend, but in the print - backends, it is impossible to suppress duplicate pages or coalesce - sequences of pages into a range. ---> - -<indexdiv><title>Symbols</title> - -<indexentry> - <primaryie>歴史 - </primaryie> - <secondaryie>Pgpool-IIの, - <ulink url="history.html" role="history">Pgpool-IIの歴史概要</ulink> - </secondaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>A</title> - -<indexentry> - <primaryie>allow_sql_comments configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN2147">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>app_name_redirect_preference_list configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN2089">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>arping_cmd configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3203">Virtual IP control</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>arping_path configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3191">Virtual IP control</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>authentication_timeout configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS" role="AEN1211">Authentication Settings</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>B</title> - -<indexentry> - <primaryie>backend_data_directory configuration parameter, - <ulink url="runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-DATA" role="AEN1537">Backend Data Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>backend_flag configuration parameter, - <ulink url="runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-DATA" role="AEN1549">Backend Data Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>backend_hostname configuration parameter, - <ulink url="runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS" role="AEN1493">Backend Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>backend_port configuration parameter, - <ulink url="runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS" role="AEN1511">Backend Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>backend_weight configuration parameter, - <ulink url="runtime-config-backend-settings.html#RUNTIME-CONFIG-BACKEND-CONNECTION-SETTINGS" role="AEN1523">Backend Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>bison, - <ulink url="install-requirements.html" role="AEN771">Requirements</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>black_function_list configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN2008">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>black_memqcache_table_list configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2870">Common configurations</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>C</title> - -<indexentry> - <primaryie>check_temp_table configuration parameter, - <ulink url="runtime-misc.html" role="AEN3604">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>check_unlogged_table configuration parameter, - <ulink url="runtime-misc.html" role="AEN3617">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>child_life_time configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1671">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>child_max_connections configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1710">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>clear_memqcache_on_escalation configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION" role="AEN3221">Behaivor on escalation and de-escalation</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>client authentication, - <ulink url="client-authentication.html" role="client-authentication">Client Authentication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>client_idle_limit configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1694">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>client_idle_limit_in_recovery configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2622">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>client_min_messages configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN-TO-LOG" role="AEN1830">When To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>configuration - </primaryie> - <secondaryie>of the server, - <ulink url="runtime-config.html" role="AEN1012">Server Configuration</ulink> - </secondaryie> -</indexentry> - -<indexentry> - <primaryie>configuring watchdog, - <ulink url="runtime-watchdog-config.html" role="runtime-watchdog-config">Watchdog</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>connection_cache configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1583">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>connection_life_time configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1728">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>connect_timeout configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2255">Health Check</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>D</title> - -<indexentry> - <primaryie>database_redirect_preference_list configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN2051">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>delay_threshold configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2697">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>delegate_IP configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3142">Virtual IP control</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>E</title> - -<indexentry> - <primaryie>enable_pool_hba configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS" role="AEN1184">Authentication Settings</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>F</title> - -<indexentry> - <primaryie>failback_command configuration parameter, - <ulink url="runtime-config-failover.html" role="AEN2330">Failover and Failback</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>failover_command configuration parameter, - <ulink url="runtime-config-failover.html" role="AEN2271">Failover and Failback</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>failover_if_affected_tuples_mismatch configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1321">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>fail_over_on_backend_error configuration parameter, - <ulink url="runtime-config-failover.html" role="AEN2443">Failover and Failback</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>flex, - <ulink url="install-requirements.html" role="AEN767">Requirements</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>follow_master_command configuration parameter, - <ulink url="runtime-config-failover.html" role="AEN2383">Failover and Failback</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>H</title> - -<indexentry> - <primaryie>health_check_database configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2213">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_max_retries configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2230">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_password configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2202">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_period configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2182">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_retry_delay configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2244">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_timeout configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2171">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>health_check_user configuration parameter, - <ulink url="runtime-config-health-check.html" role="AEN2192">Health Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>heartbeat_destination configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3409">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>heartbeat_destination_port configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3426">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>heartbeat_device configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3441">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>I</title> - -<indexentry> - <primaryie>if_cmd_path configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3155">Virtual IP control</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>if_down_cmd configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3180">Virtual IP control</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>if_up_cmd configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-VIP-CONTROL" role="AEN3167">Virtual IP control</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ignore_leading_white_space configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN1980">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>insert_lock configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1389">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>installation, - <ulink url="installation.html" role="installation">Pgpool-II Installation from Source Code</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>L</title> - -<indexentry> - <primaryie>lex, - <ulink url="install-requirements.html" role="AEN769">Requirements</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>listen_addresses configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1079">Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>listen_backlog_multiplier configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1609">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>load_balance_mode configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN1968">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>lobj_lock_table configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1442">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>logdir configuration parameter, - <ulink url="runtime-misc.html" role="AEN3642">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_connections configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1885">What To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_destination configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG" role="AEN1784">Where To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_error_verbosity configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1895">What To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_hostname configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1874">What To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_line_prefix configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1905">What To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_min_messages configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN-TO-LOG" role="AEN1840">When To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_per_node_statement configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1863">What To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_standby_delay configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2712">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>log_statement configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT-TO-LOG" role="AEN1853">What To Log</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>M</title> - -<indexentry> - <primaryie>make, - <ulink url="install-requirements.html" role="AEN734">Requirements</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>master_slave_mode configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-MASTER-SLAVE-MODE" role="AEN1236">Master slave mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>master_slave_sub_mode configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-MASTER-SLAVE-MODE" role="AEN1250">Master slave mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>max_pool configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1595">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>MD5, - <ulink url="auth-methods.html#AUTH-MD5" role="AEN3834">MD5 Password Authentication</ulink>, - <ulink url="auth-methods.html#SETTING-MD5-AUTHENTICATION" role="SETTING-MD5-AUTHENTICATION">Setting md5 Authentication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memory_cache_enabled configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-ENABLING" role="AEN2756">Enabling in memory query cache</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_auto_cache_invalidation configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2818">Common configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_cache_block_size configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG" role="AEN2930">Configurations to use shared memory</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_expire configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2804">Common configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_maxcache configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2833">Common configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_max_num_cache configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG" role="AEN2917">Configurations to use shared memory</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_memcached_host configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-MEMCACHED-CONFIG" role="AEN2949">Configurations to use memcached</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_memcached_port configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-MEMCACHED-CONFIG" role="AEN2963">Configurations to use memcached</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_method configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CHOOSE-STORAGE" role="AEN2769">Choosing cache storage</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_oiddir configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2886">Common configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>memqcache_total_size configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-SHMEM-CONFIG" role="AEN2907">Configurations to use shared memory</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>N</title> - -<indexentry> - <primaryie>num_init_children configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1153">Connection Settings</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>O</title> - -<indexentry> - <primaryie>OpenSSL, - <ulink url="install-pgpool.html" role="AEN819">Installing pgpool-II</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>other_pgpool_hostname configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION" role="AEN3539">Watchdog servers configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>other_pgpool_port configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION" role="AEN3550">Watchdog servers configurations</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>other_wd_port0 configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-SERVER-CONFIGURATION" role="AEN3561">Watchdog servers configurations</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>P</title> - -<indexentry> - <primaryie>PAM, - <ulink url="auth-methods.html#AUTH-PAM" role="AUTH-PAM">PAM Authentication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp configuration, - <ulink url="configuring-pcp-conf.html" role="AEN952">Configuring pcp.conf</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_attach_node, - <ulink url="pcp-attach-node.html" role="pcp-attach-node">pcp_attach_node</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_common_options, - <ulink url="pcp-common-options.html" role="pcp-common-options">pcp_common_options</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_detach_node, - <ulink url="pcp-detach-node.html" role="pcp-detach-node">pcp_detach_node</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_listen_addresses configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1116">Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_node_count, - <ulink url="pcp-node-count.html" role="pcp-node-count">pcp_node_count</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_node_info, - <ulink url="pcp-node-info.html" role="pcp-node-info">pcp_node_info</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_pool_status, - <ulink url="pcp-pool-status.html" role="pcp-pool-status">pcp_pool_status</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_port configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1129">Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_proc_count, - <ulink url="pcp-proc-count.html" role="pcp-proc-count">pcp_proc_count</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_proc_info, - <ulink url="pcp-proc-info.html" role="pcp-proc-info">pcp_proc_info</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_promote_node, - <ulink url="pcp-promote-node.html" role="pcp-promote-node">pcp_promote_node</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_recovery_node, - <ulink url="pcp-recovery-node.html" role="pcp-recovery-node">pcp_recovery_node</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_socket_dir configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1140">Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_stop_pgpool, - <ulink url="pcp-stop-pgpool.html" role="pcp-stop-pgpool">pcp_stop_pgpool</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pcp_watchdog_info, - <ulink url="pcp-watchdog-info.html" role="pcp-watchdog-info">pcp_watchdog_info</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>Pgpool-II configuration, - <ulink url="configuring-pgpool.html" role="AEN971">Configuring pgpool</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>Pgpool-II user, - <ulink url="pgpool-ii-user.html" role="AEN941">The Pgpool-II User Account</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pgpool.conf, - <ulink url="config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE" role="AEN1047">Parameter Interaction via the Configuration File</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pgpool_setup, - <ulink url="pgpool-setup.html" role="pgpool-setup">pgpool_setup</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pg_md5, - <ulink url="pg-md5.html" role="pg-md5">pg_md5</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pid_file_name configuration parameter, - <ulink url="runtime-misc.html" role="AEN3630">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ping_path configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-UPSTREAM-CONNECTIONS" role="AEN3128">Upstream server connection</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pool_hba.conf, - <ulink url="auth-pool-hba-conf.html" role="auth-pool-hba-conf">The pool_hba.conf File</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>pool_passwd configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-AUTHENTICATION-SETTINGS" role="AEN1199">Authentication Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>port configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1092">Connection Settings</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>R</title> - -<indexentry> - <primaryie>recovery_1st_stage_command configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2533">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>recovery_2nd_stage_command configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2572">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>recovery_password configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2522">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>recovery_timeout configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2611">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>recovery_user configuration parameter, - <ulink url="runtime-online-recovery.html" role="AEN2512">Online Recovery</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>relcache_expire configuration parameter, - <ulink url="runtime-misc.html" role="AEN3575">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>relcache_size configuration parameter, - <ulink url="runtime-misc.html" role="AEN3589">Misc Configuration Parameters</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>replicate_select configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1337">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>replication_mode configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1288">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>replication_stop_on_mismatch configuration parameter, - <ulink url="runtime-config-runnung-mode.html#RUNTIME-CONFIG-REPLICATION-MODE" role="AEN1302">Replication mode</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>RESET, - <ulink url="sql-pgpool-reset.html" role="sql-pgpool-reset">PGPOOL RESET</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>reset_query_list configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1739">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>S</title> - -<indexentry> - <primaryie>search_primary_node_timeout configuration parameter, - <ulink url="runtime-config-failover.html" role="AEN2460">Failover and Failback</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>serialize_accept configuration parameter, - <ulink url="runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS" role="AEN1629">Connection Pooling Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>SET, - <ulink url="sql-pgpool-set.html" role="sql-pgpool-set">PGPOOL SET</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>SHOW, - <ulink url="sql-pgpool-show.html" role="sql-pgpool-show">PGPOOL SHOW</ulink>, - <ulink url="sql-show-pgpool-status.html" role="sql-show-pgpool-status">SHOW PGPOOL STATUS</ulink>, - <ulink url="sql-show-pool-nodes.html" role="sql-show-pool-nodes">SHOW POOL NODES</ulink>, - <ulink url="sql-show-pool-processes.html" role="sql-show-pool-processes">SHOW POOL_PROCESSES</ulink>, - <ulink url="sql-show-pool-pools.html" role="sql-show-pool-pools">SHOW POOL_POOLS</ulink>, - <ulink url="sql-show-pool-version.html" role="sql-show-pool-version">SHOW POOL_VERSION</ulink>, - <ulink url="sql-show-pool-cache.html" role="sql-show-pool-cache">SHOW POOL_CACHE</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>SIGHUP, - <ulink url="config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE" role="AEN1054">Parameter Interaction via the Configuration File</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>socket_dir configuration parameter, - <ulink url="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" role="AEN1103">Connection Settings</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>sr_check_database configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2686">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>sr_check_password configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2674">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>sr_check_period configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2649">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>sr_check_user configuration parameter, - <ulink url="runtime-streaming-replication-check.html" role="AEN2659">Streaming Replication Check</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ssl configuration parameter, - <ulink url="runtime-ssl.html" role="AEN2977">Secure Sockect Layer (SSL)</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ssl_ca_cert configuration parameter, - <ulink url="runtime-ssl.html" role="AEN3020">Secure Sockect Layer (SSL)</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ssl_ca_cert_dir configuration parameter, - <ulink url="runtime-ssl.html" role="AEN3034">Secure Sockect Layer (SSL)</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ssl_cert configuration parameter, - <ulink url="runtime-ssl.html" role="AEN3009">Secure Sockect Layer (SSL)</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>ssl_key configuration parameter, - <ulink url="runtime-ssl.html" role="AEN2998">Secure Sockect Layer (SSL)</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>syslog_facility configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG" role="AEN1804">Where To Log</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>syslog_ident configuration parameter, - <ulink url="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE-TO-LOG" role="AEN1815">Where To Log</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>T</title> - -<indexentry> - <primaryie>trusted_servers configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-UPSTREAM-CONNECTIONS" role="AEN3116">Upstream server connection</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>U</title> - -<indexentry> - <primaryie>use_watchdog configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-ENABLE-WATCHDOG" role="AEN3059">Enable watchdog</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>W</title> - -<indexentry> - <primaryie>WATCHDOG, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-COORDINATING-NODES" role="TUTORIAL-WATCHDOG-COORDINATING-NODES">Coordinating multiple Pgpool-II nodes</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-LIFECHECKING" role="TUTORIAL-WATCHDOG-LIFECHECKING">Life checking of other Pgpool-II nodes</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CONSISTENCY-OF-CONFIG" role="TUTORIAL-WATCHDOG-CONSISTENCY-OF-CONFIG">Consistency of configuration parameters on all Pgpool-II nodes</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-ACTIVE" role="TUTORIAL-WATCHDOG-CHANGING-ACTIVE">Changing active/standby state when certain fault is detected</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-AUTOMATIC-VIP" role="TUTORIAL-WATCHDOG-AUTOMATIC-VIP">Automatic virtual IP switching</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-CHANGING-AUTOMATIC-REGISTER-IN-RECOVERY" role="TUTORIAL-WATCHDOG-CHANGING-AUTOMATIC-REGISTER-IN-RECOVERY">Automatic registration of a server as a standby in recovery</ulink>, - <ulink url="tutorial-watchdog-intro.html#TUTORIAL-WATCHDOG-START-STOP" role="TUTORIAL-WATCHDOG-START-STOP">Starting/stopping watchdog</ulink>, - <ulink url="tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET" role="TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET">Watchdog IPC command packet format</ulink>, - <ulink url="tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-RESULT-PACKET" role="TUTORIAL-WATCHDOG-IPC-RESULT-PACKET">Watchdog IPC result packet format</ulink>, - <ulink url="tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET-TYPES" role="TUTORIAL-WATCHDOG-IPC-COMMAND-PACKET-TYPES">Watchdog IPC command packet types</ulink>, - <ulink url="tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-IPC" role="TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-IPC">External lifecheck IPC packets and data</ulink>, - <ulink url="tutorial-watchdog-integrating-external-lifecheck.html#TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-GET-NODES" role="TUTORIAL-WATCHDOG-EXTERNAL-LIFECHECK-GET-NODES">Getting list of configured watchdog nodes</ulink>, - <ulink url="tutorial-watchdog-restrictions.html" role="tutorial-watchdog-restrictions">Restrictions on watchdog</ulink>, - <ulink url="tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-QUERY-MODE" role="TUTORIAL-WATCHDOG-RESTRICTIONS-QUERY-MODE">Watchdog restriction with query mode lifecheck</ulink>, - <ulink url="tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-MODE" role="TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-MODE">Connecting to Pgpool-II whose watchdog status is down</ulink>, - <ulink url="tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-REQUIRE-RESTART" role="TUTORIAL-WATCHDOG-RESTRICTIONS-DOWN-WATCHDOG-REQUIRE-RESTART">Pgpool-II whose watchdog status is down requires restart</ulink>, - <ulink url="tutorial-watchdog-restrictions.html#TUTORIAL-WATCHDOG-RESTRICTIONS-ACTIVE-TAKE-TIME" role="TUTORIAL-WATCHDOG-RESTRICTIONS-ACTIVE-TAKE-TIME">Watchdog promotion to active takes few seconds</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>watchdog_setup, - <ulink url="watchdog-setup.html" role="watchdog-setup">watchdog_setup</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_authkey configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG" role="AEN3093">Watchdog communication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_de_escalation_command configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION" role="AEN3247">Behaivor on escalation and de-escalation</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_escalation_command configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-ESCALATION-DE-ESCALATION" role="AEN3236">Behaivor on escalation and de-escalation</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_heartbeat_deadtime configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3395">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_heartbeat_keepalive configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3382">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_heartbeat_port configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-HEARTBEAT" role="AEN3368">Lifecheck Heartbeat mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_hostname configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG" role="AEN3072">Watchdog communication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_interval configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK" role="AEN3320">Life checking Pgpool-II </ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_ipc_socket_dir configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK" role="AEN3346">Life checking Pgpool-II </ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_lifecheck_dbname configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY" role="AEN3488">Lifecheck Query mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_lifecheck_method configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK" role="AEN3269">Life checking Pgpool-II </ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_lifecheck_password configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY" role="AEN3520">Lifecheck Query mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_lifecheck_query configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY" role="AEN3472">Lifecheck Query mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_lifecheck_user configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY" role="AEN3504">Lifecheck Query mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_life_point configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK-QUERY" role="AEN3458">Lifecheck Query mode configuration</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_monitoring_interfaces_list configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK" role="AEN3302">Life checking Pgpool-II </ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_port configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-COMMUNICATION-WATCHDOG" role="AEN3083">Watchdog communication</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>wd_priority configuration parameter, - <ulink url="runtime-watchdog-config.html#CONFIG-WATCHDOG-LIFECHECK" role="AEN3331">Life checking Pgpool-II </ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>white_function_list configuration parameter, - <ulink url="runtime-config-load-balancing.html" role="AEN1991">Load Balancing</ulink> - </primaryie> -</indexentry> - -<indexentry> - <primaryie>white_memqcache_table_list configuration parameter, - <ulink url="runtime-in-memory-query-cache.html#RUNTIME-IN-MEMORY-QUERY-CACHE-CONFIG" role="AEN2851">Common configurations</ulink> - </primaryie> -</indexentry> - -</indexdiv> -<indexdiv><title>Y</title> - -<indexentry> - <primaryie>yacc, - <ulink url="install-requirements.html" role="AEN773">Requirements</ulink> - </primaryie> -</indexentry> - -</indexdiv> -</index> diff --git a/doc.ja/src/sgml/restrictions.sgml b/doc.ja/src/sgml/restrictions.sgml index 5e4bce78f..234676293 100644 --- a/doc.ja/src/sgml/restrictions.sgml +++ b/doc.ja/src/sgml/restrictions.sgml @@ -1,17 +1,27 @@ <!-- doc/src/sgml/restrictions.sgml --> <sect1 id="restrictions"> +<!-- <title>Restrictions</title> +--> + <title>制限事項</title> <para> +<!-- This section descibes current restrictions of <productname>Pgpool-II</productname>. +--> +この章では、<productname>Pgpool-II</productname>の現在の制限事項について説明します。 <variablelist> <varlistentry> +<!-- <term>Functionality of PostgreSQL</term> +--> + <term>PostgreSQLの機能</term> <listitem> <para> +<!-- If you use <function>pg_terminate_backend()</function> to stop a backend, this will trigger a failover. The reason why this happens is that <productname>PostgreSQL</productname> sends @@ -21,61 +31,95 @@ the argument to the function (that is a process id) is a constant, you can safely use the function. In extended protocol mode, you cannot use the function though. +--> +<function>pg_terminate_backend()</function>を使ってバックエンドを停止すると、フェイルオーバが起こります。 +これは、<productname>PostgreSQL</productname>が、postmasterの停止と全く同じメッセージをバックエンド停止時に送るためです。 +3.6より前のバージョンには回避策はありません。 +3.6以降では、この制限は緩和されています。 +その関数の引数(プロセスIDです)が定数なら、その関数を使っても安全です。 +しかし、拡張プロトコルでは、その関数は使えません。 </para> </listitem> </varlistentry> <varlistentry> +<!-- <term>Authentication/Access Controls</term> +--> + <term>認証/アクセス制御</term> <listitem> <para> +<!-- In the replication mode or master/slave mode, trust, clear text password, and pam methods are supported. md5 in also supported since <productname>Pgpool-II</productname> 3.0. md5 is supported by using a authencitaion file <filename>pool_passwd</filename>. <filename>pool_passwd</filename> is default name of the - authentication file. You can change the file name - using <application>pool_passwd</application>. Here are the + authentication file. Here are the steps to enable md5 authentication: +--> +レプリケーションモードまたマスタ/スレーブモード時にはtrust、reject、clear text password、pam認証方式が利用できます。 +crypt認証は利用できません。 +<productname>Pgpool-II</productname> 3.0以降では、<filename>pool_passwd</filename>というファイルを使ってmd5認証も使えます。 +<filename>pool_passwd</filename>はデフォルトの認証ファイル名です。 +md5認証を有効にする手順を示します。 </para> <orderedlist> <listitem> <para> +<!-- Login as the database's operating system user and type: +--> +DBユーザのOSアカウントでログインし、以下を実行します。 <programlisting> pg_md5 --md5auth --username=<literal>your_username</literal> <literal>your_passwd</literal> </programlisting> +<!-- user name and md5 encrypted password are registered into pool_passwd. If pool_passwd does not exist yet, pg_md5 command will automatically create it for you. The format of pool_passwd is <literal>username:encrypted_passwd</literal>. +--> +>md5により暗号化されたユーザ名とパスワードがpool_passwdに登録されます。 +pool_passwdがまだ存在しなければ、pg_md5コマンドは、自動的にpgpool.confと同じディレクトリ内にpool_passwdwを作成します。 +pool_passwdのフォーマットは、<literal>username:encrypted_passwd</literal>です。 </para> </listitem> <listitem> <para> +<!-- You also need to add an appropriate md5 entry to pool_hba.conf. See Setting up pool_hba.conf for client authentication (HBA) for more details. +--> +また、pool_hba.confに適当なmd5のエントリを作成する必要があります。 +詳細は<xref linkend="auth-pool-hba-conf">を見てください。 </para> </listitem> <listitem> <para> +<!-- Please note that the user name and password must be identical to those registered in <productname>PostgreSQL</productname>. +--> +pool_passwdに登録するパスワードは、<productname>PostgreSQL</productname>に登録したパスワードと完全に同じでなければなりません。 </para> </listitem> <listitem> <para> +<!-- After changing md5 password (in both pool_passwd and PostgreSQL of course), you need to execute <application>pgpool reload</application>. +--> +md5パスワード(もちろんpool_passwdとPostgreSQLの両方)を変更したら、pgpool reload を実行してください。 </para> </listitem> </orderedlist> @@ -84,24 +128,52 @@ </varlistentry> <varlistentry> +<!-- <term>Large objects</term> +--> + <term>ラージオブジェクト</term> <listitem> <para> - <productname>Pgpool-II</productname> supports large object - replication in replication mode if the backend +<!-- + In streaming replication + mode, <productname>Pgpool-II</productname> supports large + objects. +--> +ストリーミングレプリケーションモードでは、<productname>Pgpool-II</productname>はラージオブジェクトをサポートしています。 + </para> + <para> +<!-- + In native replication + mode, <productname>Pgpool-II</productname> supports large + objects if the backend is <productname>PostgreSQL</productname> 8.1 or later. For this, you need to enable lobj_lock_table directive in <filename>pgpool.conf</filename>. Large object replication using backend function <function>lo_import</function> is not supported, however. +--> +ネィティブレプリケーションモードでは、<productname>PostgreSQL</productname> 8.1以降ならばラージオブジェクトをサポートします。 +その際には、<filename>pgpool.conf</filename>のlobj_lock_tableを有効にしてください。 +なお、バックエンド関数の<function>lo_import</function>を使ったラージオブジェクトのレプリケーションはサポートされていません。 + </para> + <para> +<!-- + In other mode, including Slony mode, large + objects are not supported. +--> +Slonyモードも含め、その他のモードではラージオブジェクトはサポートされていません。 </para> </listitem> </varlistentry> <varlistentry> +<!-- <term>Temporary tables in master/slave mode</term> +--> + <term>一時テーブル</term> <listitem> <para> +<!-- Creating/inserting/updating/deleting temporary tables are always executed on the master (primary) in master slave mode. SELECT on these tables is executed on master as well. However @@ -110,30 +182,81 @@ balanced. That will trigger a "not found the table" error or will find another table having same name. To avoid the problem, use /*NO LOAD BALANCE*/ SQL comment. - Sample SELECT which causes a problem: +--> +一時テーブルの作成、挿入、更新、削除は、常にマスター(プライマリ)で実行されます。 +テーブルに対するSELECTもマスター上で実行されます。 +しかし、一時テーブル名が文字列としてSELECTで使われると、それを検知する方法がないため、SELECTは負荷分散されます。 +これにより、「テーブルが見つからない」エラーになったり、同じ名前を持つ別のテーブルを検索することになります。 +この問題を回避するには、/*NO LOAD BALANCE*/ SQLコメントを使ってください。 + </para> + <para> +<!-- + Note that such literal table names used in queries to access + system catalogs do cause problems described above. psql's \d + command produces such that query: + <programlisting> +SELECT 't1'::regclass::oid; + </programlisting> + In such that case <productname>Pgpool-II</productname> always + sends the query to master and will not cause the problem. +--> +ちなみに、psqlの\dコマンドのように、システムカタログを問い合わせる中で +文字列としてのテーブル名を使っている場合: <programlisting> - SELECT 't1'::regclass::oid; +SELECT 't1'::regclass::oid; </programlisting> - psql's \d command uses literal table - names. <productname>Pgpool-II</productname> checks if the - SELECT includes any access to system catalogs and always send - these queries to the master. Thus we avoid the problem. +pgpool-II 3.0以降ではマスタで検索が行なわれるので、問題になりません。 +なぜなら、システムカタログへの検索は常にマスタで行なわれるからです。 + </para> + + <para> +<!-- + Tables created by <command>CREATE TEMP TABLE</command> will be + deleted at the end of the session by specifying DISCARD ALL in + reset_query_list if you are using PostgreSQL 8.3 or later. +--> +PostgreSQL 8.3以後を使っているのであれば、<command>CREATE TEMP TABLE</command>によって作成されたテーブルは、reset_query_list中のDISCARD ALLを指定することによってセッションの最後で削除されます。 </para> + <para> +<!-- + For 8.2.x or earlier, tables created by <command>CREATE TEMP + TABLE</command> will not be deleted after exiting a + session. It is because of the connection pooling which, from + PostgreSQL's backend point of view, keeps the session + alive. To avoid this, you must explicitly drop the temporary + tables by issuing <command>DROP TABLE</command>, or + use <command>CREATE TEMP TABLE ... ON COMMIT DROP</command> + inside the transaction block. +--> +8.2.x以前では、<command>CREATE TEMP TABLE</command>によって作成されたテーブルは、セッションを終了した後に削除されません。 +PostgreSQLバックエンドから見ると、コネクションプールによってセッションが維持されているからです。 +これを回避するには、明示的に<command>DROP TABLE</command>を発行するか、トランザクションブロックの内側で<command>CREATE TEMP TABLE ... ON COMMIT DROP</command>を実施します。 + </para> + </listitem> </varlistentry> <varlistentry> +<!-- <term>Functions, etc. In replication mode</term> +--> + <term>ネィティブレプリケーションモードにおける関数などの扱い</term> <listitem> <para> +<!-- There is no guarantee that any data provided using a context-dependent mechanism (e.g. random number, transaction ID, OID, SERIAL, sequence), will be replicated correctly on multiple backends. For SERIAL, enabling insert_lock will help replicating data. insert_lock also helps SELECT setval() and SELECT nextval(). +--> +文脈依存の仕組み(たとえば乱数やトランザクションID、OID、SERIAL、シーケンス)を使って提供されるデータが複数のバックエンドに正しくレプリケーションされる保証はありません。 +SERIALに対しては、insert_lockを使って対応できます。 +SELECT setval()とSELECT nextval()に対してもinsert_lockで対応できます。 </para> <para> +<!-- INSERT/UPDATE using <function>CURRENT_TIMESTAMP</function>, <function>CURRENT_DATE</function>, <function>now()</function> will be replicated @@ -143,74 +266,92 @@ be replicated correctly. This is done by replacing those functions by constants fetched from master at query execution time. There are a few limitations however: +--> +<function>CURRENT_TIMESTAMP</function>、<function>CURRENT_DATE</function>、<function>now()</function>を含むINSERT/UPDATEは正しくレプリケーションされます。 +<function>CURRENT_TIMESTAMP</function>、<function>CURRENT_DATE</function>、<function>now()</function>をデフォルト値として使うINSERT/UPDATEも正しくレプリケーションされます。 +これは、関数を、クエリ実行時にマスターから取得した定数に置き換えることで達成されています。 +しかし、いくつか制限事項があります。 </para> <para> +<!-- In <productname>Pgpool-II</productname> 3.0 or before, the calculation of temporal data in table default value is not accurate in some cases. For example, the following table definition: +--> +<productname>Pgpool-II</productname> 3.0以前では、テーブルのデフォルト値としての時制データが正しく計算されない場合があります。 +例として以下のテーブル定義を示します。 <programlisting> CREATE TABLE rel1( d1 date DEFAULT CURRENT_DATE + 1 ) </programlisting> +<!-- is treated the same as: +--> +これは次と同じに扱われます。 <programlisting> CREATE TABLE rel1( d1 date DEFAULT CURRENT_DATE ) </programlisting> +<!-- <productname>Pgpool-II</productname> 3.1 or later handles these cases correctly. Thus the column "d1" will have tomorrow as the default value. However this enhancement does - not apply if extended protocols(used in JDBC, PHP PDO for + not apply if extended protocols (used in JDBC, PHP PDO for example) or PREPARE are used. +--> +<productname>Pgpool-II</productname> 3.1以降はこのケースを正しく扱います。 +ですのでd1列はtomorrowがデフォルト値になります。 +しかし、この改善は拡張プロトコル(たとえばJDBC、PHP PDO)やPREPAREが使用されている場合には適用されません。 </para> <para> +<!-- Please note that if the column type is not a temporal one, rewriting is not performed. Such example: +--> +列の型が時制ではない場合は書き換えは行われないことに注意してください。 +そのような例を示します。 <programlisting> foo bigint default (date_part('epoch'::text,('now'::text)::timestamp(3) with time zone) * (1000)::double precision) </programlisting> +<!-- Suppose we have the following table: +--> +以下のテーブルがあるとします。 <programlisting> CREATE TABLE rel1( c1 int, c2 timestamp default now() ) </programlisting> +<!-- We can replicate +--> <programlisting> INSERT INTO rel1(c1) VALUES(1) </programlisting> - +<!-- since this turn into - +--> +これは以下に書き換えられるものの、 <programlisting> INSERT INTO rel1(c1, c2) VALUES(1, '2009-01-01 23:59:59.123456+09') </programlisting> - +<!-- However, +--> <programlisting> INSERT INTO rel1(c1) SELECT 1 </programlisting> +<!-- cannot to be transformed, thus cannot be properly replicated in the current implementation. Values will still be inserted, with no transformation at all. - </para> - - <para> - Tables created by <command>CREATE TEMP TABLE</command> will be - deleted at the end of the session by specifying DISCARD ALL in - reset_query_list if you are using PostgreSQL 8.3 or later. - </para> - <para> - For 8.2.x or earlier, <command>CREATE TEMP TABLE</command> - will not be deleted after exiting a session. It is because of - the connection pooling which, from PostgreSQL's backend point - of view, keeps the session alive. To avoid this, you must - explicitly drop the temporary tables by issuing <command>DROP - TABLE</command>, or use <command>CREATE TEMP TABLE ... ON - COMMIT DROP</command> inside the transaction block. +--> +は変換されません。 +ですので現在の実装では正しくレプリケーションされません。 +値は挿入されますが、全く変換が行われません。 </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/restrictions.sgml b/doc/src/sgml/restrictions.sgml index 5e4bce78f..7a94d42d1 100644 --- a/doc/src/sgml/restrictions.sgml +++ b/doc/src/sgml/restrictions.sgml @@ -34,8 +34,7 @@ supported since <productname>Pgpool-II</productname> 3.0. md5 is supported by using a authencitaion file <filename>pool_passwd</filename>. <filename>pool_passwd</filename> is default name of the - authentication file. You can change the file name - using <application>pool_passwd</application>. Here are the + authentication file. Here are the steps to enable md5 authentication: </para> @@ -58,8 +57,7 @@ <listitem> <para> You also need to add an appropriate md5 entry to - pool_hba.conf. See Setting up pool_hba.conf for client - authentication (HBA) for more details. + pool_hba.conf. See <xref linkend="auth-pool-hba-conf"> for more details. </para> </listitem> @@ -87,19 +85,29 @@ <term>Large objects</term> <listitem> <para> - <productname>Pgpool-II</productname> supports large object - replication in replication mode if the backend + In streaming replication + mode, <productname>Pgpool-II</productname> supports large + objects. + </para> + <para> + In native replication + mode, <productname>Pgpool-II</productname> supports large + objects if the backend is <productname>PostgreSQL</productname> 8.1 or later. For this, you need to enable lobj_lock_table directive in <filename>pgpool.conf</filename>. Large object replication using backend function <function>lo_import</function> is not supported, however. </para> + <para> + In other mode, including Slony mode, large + objects are not supported. + </para> </listitem> </varlistentry> <varlistentry> - <term>Temporary tables in master/slave mode</term> + <term>Temporary tables</term> <listitem> <para> Creating/inserting/updating/deleting temporary tables are @@ -110,20 +118,39 @@ balanced. That will trigger a "not found the table" error or will find another table having same name. To avoid the problem, use /*NO LOAD BALANCE*/ SQL comment. - Sample SELECT which causes a problem: + </para> + <para> + Note that such literal table names used in queries to access + system catalogs do cause problems described above. psql's \d + command produces such that query: <programlisting> - SELECT 't1'::regclass::oid; +SELECT 't1'::regclass::oid; </programlisting> - psql's \d command uses literal table - names. <productname>Pgpool-II</productname> checks if the - SELECT includes any access to system catalogs and always send - these queries to the master. Thus we avoid the problem. + In such that case <productname>Pgpool-II</productname> always + sends the query to master and will not cause the problem. + </para> + + <para> + Tables created by <command>CREATE TEMP TABLE</command> will be + deleted at the end of the session by specifying DISCARD ALL in + reset_query_list if you are using PostgreSQL 8.3 or later. + </para> + <para> + For 8.2.x or earlier, tables created by <command>CREATE TEMP + TABLE</command> will not be deleted after exiting a + session. It is because of the connection pooling which, from + PostgreSQL's backend point of view, keeps the session + alive. To avoid this, you must explicitly drop the temporary + tables by issuing <command>DROP TABLE</command>, or + use <command>CREATE TEMP TABLE ... ON COMMIT DROP</command> + inside the transaction block. </para> + </listitem> </varlistentry> <varlistentry> - <term>Functions, etc. In replication mode</term> + <term>Functions, etc. In Native Replication mode</term> <listitem> <para> There is no guarantee that any data provided using a @@ -163,7 +190,7 @@ CREATE TABLE rel1( <productname>Pgpool-II</productname> 3.1 or later handles these cases correctly. Thus the column "d1" will have tomorrow as the default value. However this enhancement does - not apply if extended protocols(used in JDBC, PHP PDO for + not apply if extended protocols (used in JDBC, PHP PDO for example) or PREPARE are used. </para> <para> @@ -196,21 +223,6 @@ INSERT INTO rel1(c1) SELECT 1 </programlisting> cannot to be transformed, thus cannot be properly replicated in the current implementation. Values will still be inserted, with no transformation at all. - </para> - - <para> - Tables created by <command>CREATE TEMP TABLE</command> will be - deleted at the end of the session by specifying DISCARD ALL in - reset_query_list if you are using PostgreSQL 8.3 or later. - </para> - <para> - For 8.2.x or earlier, <command>CREATE TEMP TABLE</command> - will not be deleted after exiting a session. It is because of - the connection pooling which, from PostgreSQL's backend point - of view, keeps the session alive. To avoid this, you must - explicitly drop the temporary tables by issuing <command>DROP - TABLE</command>, or use <command>CREATE TEMP TABLE ... ON - COMMIT DROP</command> inside the transaction block. </para> </listitem> </varlistentry> [parent: 6ffc3429b2ea]