Index
Symbols | A | B | C | D | E | F | G | H | I | L | M | N | O | P | Q | R | S | T | U | W | Y
- AES256,
Using AES256 encrypted passwords in
- allow_clear_text_frontend_auth configuration parameter,
Authentication Settings
- allow_multiple_failover_requests_from_node configuration parameter,
Controlling the Failover behavior
- allow_sql_comments configuration parameter,
Load Balancing Settings
- app_name_redirect_preference_list configuration parameter,
Load Balancing Settings
- arping_cmd configuration parameter,
Virtual IP control
- arping_path configuration parameter,
Virtual IP control
- AUTH,
Using different methods for frontend and backend authentication,
Using AES256 encrypted passwords in
- authentication_timeout configuration parameter,
Authentication Settings
- auto_failback configuration parameter,
Failover and Failback Settings
- auto_failback_interval configuration parameter,
Failover and Failback Settings
- cache_safe_memqcache_table_list configuration parameter,
Common configurations
- cache_unsafe_memqcache_table_list configuration parameter,
Common configurations
- Certificate,
Certificate Authentication
- check_temp_table configuration parameter,
Misc Configuration Parameters
- check_unlogged_table configuration parameter,
Misc Configuration Parameters
- child_life_time configuration parameter,
Connection Pooling Settings
- child_max_connections configuration parameter,
Connection Pooling Settings
- clear_memqcache_on_escalation configuration parameter,
Behaviour on escalation and de-escalation
- client authentication,
Client Authentication
- client_idle_limit configuration parameter,
Connection Pooling Settings
- client_idle_limit_in_recovery configuration parameter,
Online Recovery
- client_min_messages configuration parameter,
When To Log
- configuration
- of the server,
Server Configuration
- configuring watchdog,
Watchdog
- connection_cache configuration parameter,
Connection Pooling Settings
- connection_life_time configuration parameter,
Connection Pooling Settings
- connect_timeout configuration parameter,
Health Check
- health_check_database configuration parameter,
Health Check
- health_check_max_retries configuration parameter,
Health Check
- health_check_password configuration parameter,
Health Check
- health_check_period configuration parameter,
Health Check
- health_check_retry_delay configuration parameter,
Health Check
- health_check_test configuration parameter,
Misc Configuration Parameters
- health_check_timeout configuration parameter,
Health Check
- health_check_user configuration parameter,
Health Check
- heartbeat_deviceX configuration parameter,
Lifecheck Heartbeat mode configuration
- heartbeat_hostnameX configuration parameter,
Lifecheck Heartbeat mode configuration
- heartbeat_portX configuration parameter,
Lifecheck Heartbeat mode configuration
- history
- of Pgpool-II,
A Brief History of Pgpool-II
- hostnameX configuration parameter,
Watchdog communication
- LDAP,
LDAP Authentication
- lex,
Requirements
- listen_addresses configuration parameter,
Connection Settings
- listen_backlog_multiplier configuration parameter,
Connection Pooling Settings
- load_balance_mode configuration parameter,
Load Balancing Settings
- lobj_lock_table configuration parameter,
Native replication mode
- logdir configuration parameter,
Misc Configuration Parameters
- logging_collector configuration parameter,
Where To Log
- logical replication mode,
Running mode of Pgpool-II
- log_client_messages configuration parameter,
What To Log
- log_connections configuration parameter,
What To Log
- log_destination configuration parameter,
Where To Log
- log_directory configuration parameter,
Where To Log
- log_disconnections configuration parameter,
What To Log
- log_error_verbosity configuration parameter,
What To Log
- log_filename configuration parameter,
Where To Log
- log_file_mode configuration parameter,
Where To Log
- log_hostname configuration parameter,
What To Log
- log_line_prefix configuration parameter,
What To Log
- log_min_messages configuration parameter,
When To Log
- log_per_node_statement configuration parameter,
What To Log
- log_rotation_age configuration parameter,
Where To Log
- log_rotation_size configuration parameter,
Where To Log
- log_standby_delay configuration parameter,
Streaming Replication Check
- log_statement configuration parameter,
What To Log
- log_truncate_on_rotation configuration parameter,
Where To Log
- main replica mode,
Running mode of Pgpool-II
- make,
Requirements
- max_pool configuration parameter,
Connection Pooling Settings
- MD5,
MD5 Password Authentication,
Setting md5 Authentication
- memory_cache_enabled configuration parameter,
Enabling in memory query cache
- memqcache_auto_cache_invalidation configuration parameter,
Common configurations
- memqcache_cache_block_size configuration parameter,
Configurations to use shared memory
- memqcache_expire configuration parameter,
Common configurations
- memqcache_maxcache configuration parameter,
Common configurations
- memqcache_max_num_cache configuration parameter,
Configurations to use shared memory
- memqcache_memcached_host configuration parameter,
Configurations to use memcached
- memqcache_memcached_port configuration parameter,
Configurations to use memcached
- memqcache_method configuration parameter,
Choosing cache storage
- memqcache_oiddir configuration parameter,
Common configurations
- memqcache_total_size configuration parameter,
Configurations to use shared memory
- PAM,
PAM Authentication
- pcp configuration,
Configuring pcp.conf
- PCPPASSFILE,
PCP password file
- pcp_attach_node,
pcp_attach_node
- pcp_common_options,
pcp_common_options
- pcp_detach_node,
pcp_detach_node
- pcp_health_check_stats,
pcp_health_check_stats
- pcp_listen_addresses configuration parameter,
Connection Settings
- pcp_node_count,
pcp_node_count
- pcp_node_info,
pcp_node_info
- pcp_pool_status,
pcp_pool_status
- pcp_port configuration parameter,
Connection Settings
- pcp_proc_count,
pcp_proc_count
- pcp_proc_info,
pcp_proc_info
- pcp_promote_node,
pcp_promote_node
- pcp_recovery_node,
pcp_recovery_node
- pcp_reload_config,
pcp_reload_config
- pcp_socket_dir configuration parameter,
Connection Settings
- pcp_stop_pgpool,
pcp_stop_pgpool
- pcp_watchdog_info,
pcp_watchdog_info
- performance
- of the server,
Performance Considerations
- pgpool,
pgpool
- Pgpool-II configuration,
Configuring Pgpool-II
- Pgpool-II user,
The Pgpool-II User Account
- pgpool.conf,
Parameter Interaction via the Configuration File
- pgpoolkey,
Providing decryption key to Pgpool-II
- PGPOOLKEYFILE,
Providing decryption key to Pgpool-II
- pgpool_adm_pcp_attach_node,
pgpool_adm_pcp_attach_node
- pgpool_adm_pcp_detach_node,
pgpool_adm_pcp_detach_node
- pgpool_adm_pcp_health_check_stats,
pgpool_adm_pcp_health_check_stats
- pgpool_adm_pcp_node_count,
pgpool_adm_pcp_node_count
- pgpool_adm_pcp_node_info,
pgpool_adm_pcp_node_info
- pgpool_adm_pcp_pool_status,
pgpool_adm_pcp_pool_status
- pgpool_portX configuration parameter,
Watchdog communication
- pgpool_setup,
pgpool_setup
- pgproto,
pgproto
- pg_enc,
pg_enc
- pg_md5,
pg_md5
- pid_file_name configuration parameter,
Misc Configuration Parameters
- ping_path configuration parameter,
Upstream server connection
- pool_hba.conf,
The pool_hba.conf File
- pool_passwd configuration parameter,
Authentication Settings
- port configuration parameter,
Connection Settings
- primary_routing_query_pattern_list configuration parameter,
Load Balancing Settings
- read_only_function_list configuration parameter,
Load Balancing Settings
- recovery_1st_stage_command configuration parameter,
Online Recovery
- recovery_2nd_stage_command configuration parameter,
Online Recovery
- recovery_password configuration parameter,
Online Recovery
- recovery_timeout configuration parameter,
Online Recovery
- recovery_user configuration parameter,
Online Recovery
- relcache_expire configuration parameter,
Misc Configuration Parameters
- relcache_query_target configuration parameter,
Misc Configuration Parameters
- relcache_size configuration parameter,
Misc Configuration Parameters
- replicate_select configuration parameter,
Native replication mode
- replication_stop_on_mismatch configuration parameter,
Native replication mode
- reserved_connections configuration parameter,
Connection Settings
- RESET,
PGPOOL RESET
- reset_query_list configuration parameter,
Connection Pooling Settings
- SCRAM,
scram-sha-256 Authentication,
Setting scram-sha-256 Authentication
- search_primary_node_timeout configuration parameter,
Failover and Failback Settings
- serialize_accept configuration parameter,
Connection Pooling Settings
- SET,
PGPOOL SET
- SHOW,
PGPOOL SHOW,
SHOW POOL_CACHE
- SHOW POOL_BACKEND_STATS,
SHOW POOL_BACKEND_STATS
- SHOW POOL_HEALTH_CHECK_STATS,
SHOW POOL_HEALTH_CHECK_STATS
- SHOW POOL_NODES,
SHOW POOL NODES
- SHOW POOL_POOLS,
SHOW POOL_POOLS
- SHOW POOL_PROCESSES,
SHOW POOL_PROCESSES
- SHOW POOL_STATUS,
SHOW POOL STATUS
- SHOW POOL_VERSION,
SHOW POOL_VERSION
- shutdown,
Stopping Pgpool-II and PostgreSQL,
Temporarily Shutting Down PostgreSQL
- SIGHUP,
Parameter Interaction via the Configuration File
- snapshot isolation mode,
Running mode of Pgpool-II
- socket_dir configuration parameter,
Connection Settings
- sr_check_database configuration parameter,
Streaming Replication Check
- sr_check_password configuration parameter,
Streaming Replication Check
- sr_check_period configuration parameter,
Streaming Replication Check
- sr_check_user configuration parameter,
Streaming Replication Check
- ssl configuration parameter,
SSL Settings
- ssl_ca_cert configuration parameter,
SSL Settings
- ssl_ca_cert_dir configuration parameter,
SSL Settings
- ssl_cert configuration parameter,
SSL Settings
- ssl_ciphers configuration parameter,
SSL Settings
- ssl_crl_file configuration parameter,
SSL Settings
- ssl_dh_params_file configuration parameter,
SSL Settings
- ssl_ecdh_curve configuration parameter,
SSL Settings
- ssl_key configuration parameter,
SSL Settings
- ssl_passphrase_command configuration parameter,
SSL Settings
- ssl_prefer_server_ciphers configuration parameter,
SSL Settings
- statement_level_load_balance configuration parameter,
Load Balancing Settings
- streaming replication mode,
Running mode of Pgpool-II
- syslog_facility configuration parameter,
Where To Log
- syslog_ident configuration parameter,
Where To Log
- WATCHDOG,
Coordinating multiple Pgpool-II nodes,
Life checking of other Pgpool-II nodes,
Consistency of configuration parameters on all Pgpool-II nodes,
Changing active/standby state when certain fault is detected,
Automatic virtual IP switching,
Automatic registration of a server as a standby in recovery,
Starting/stopping watchdog,
Watchdog IPC command packet format,
Watchdog IPC result packet format,
Watchdog IPC command packet types,
External lifecheck IPC packets and data,
Getting list of configured watchdog nodes,
Restrictions on watchdog,
Watchdog restriction with query mode lifecheck,
Connecting to Pgpool-II whose watchdog status is down,
Pgpool-II whose watchdog status is down requires restart,
Watchdog promotion to active takes few seconds
- watchdog_setup,
watchdog_setup
- wd_authkey configuration parameter,
Watchdog communication
- wd_cli,
wd_cli
- wd_de_escalation_command configuration parameter,
Behaviour on escalation and de-escalation
- wd_escalation_command configuration parameter,
Behaviour on escalation and de-escalation
- wd_heartbeat_deadtime configuration parameter,
Lifecheck Heartbeat mode configuration
- wd_heartbeat_keepalive configuration parameter,
Lifecheck Heartbeat mode configuration
- wd_interval configuration parameter,
Life checking Pgpool-II
- wd_ipc_socket_dir configuration parameter,
Life checking Pgpool-II
- wd_lifecheck_dbname configuration parameter,
Lifecheck Query mode configuration
- wd_lifecheck_method configuration parameter,
Life checking Pgpool-II
- wd_lifecheck_password configuration parameter,
Lifecheck Query mode configuration
- wd_lifecheck_query configuration parameter,
Lifecheck Query mode configuration
- wd_lifecheck_user configuration parameter,
Lifecheck Query mode configuration
- wd_life_point configuration parameter,
Lifecheck Query mode configuration
- wd_monitoring_interfaces_list configuration parameter,
Life checking Pgpool-II
- wd_portX configuration parameter,
Watchdog communication
- wd_priority configuration parameter,
Life checking Pgpool-II
- write_function_list configuration parameter,
Load Balancing Settings