Index

A

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

B

backend_data_directory configuration parameter, Backend Data Settings
backend_flag configuration parameter, Backend Data Settings
backend_hostname configuration parameter, Backend Connection Settings
backend_port configuration parameter, Backend Connection Settings
backend_weight configuration parameter, Backend Connection Settings
bison, Requirements
black_function_list configuration parameter, Load Balancing Settings
black_memqcache_table_list configuration parameter, Common configurations
black_query_pattern_list configuration parameter, Load Balancing Settings

C

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, Behaivor 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

D

database_redirect_preference_list configuration parameter, Load Balancing Settings
delay_threshold configuration parameter, Streaming Replication Check
delegate_IP configuration parameter, Virtual IP control
detach_false_primary configuration parameter, Failover and Failback Settings
disable_load_balance_on_write configuration parameter, Load Balancing Settings

E

enable_pool_hba configuration parameter, Authentication Settings

F

failback_command configuration parameter, Failover and Failback Settings
failover_command configuration parameter, Failover and Failback Settings
failover_if_affected_tuples_mismatch configuration parameter, Replication mode
failover_on_backend_error configuration parameter, Failover and Failback Settings
failover_require_consensus configuration parameter, Controlling the Failover behavior
failover_when_quorum_exists configuration parameter, Controlling the Failover behavior
flex, Requirements
follow_master_command configuration parameter, Failover and Failback Settings

H

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_timeout configuration parameter, Health Check
health_check_user configuration parameter, Health Check
heartbeat_destination configuration parameter, Lifecheck Heartbeat mode configuration
heartbeat_destination_port configuration parameter, Lifecheck Heartbeat mode configuration
heartbeat_device configuration parameter, Lifecheck Heartbeat mode configuration
history
of Pgpool-II, A Brief History of Pgpool-II

I

if_cmd_path configuration parameter, Virtual IP control
if_down_cmd configuration parameter, Virtual IP control
if_up_cmd configuration parameter, Virtual IP control
ignore_leading_white_space configuration parameter, Load Balancing Settings
insert_lock configuration parameter, Replication mode
installation, Installation of Pgpool-II

L

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, Replication mode
logdir configuration parameter, Misc Configuration Parameters
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_error_verbosity configuration parameter, What 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_standby_delay configuration parameter, Streaming Replication Check
log_statement configuration parameter, What To Log

M

make, Requirements
master slave mode, Running mode of Pgpool-II
master_slave_mode configuration parameter, Master slave mode
master_slave_sub_mode configuration parameter, Master slave mode
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

N

native replication mode, Running mode of Pgpool-II
num_init_children configuration parameter, Connection Settings

O

other_pgpool_hostname configuration parameter, Watchdog servers configurations
other_pgpool_port configuration parameter, Watchdog servers configurations
other_wd_port0 configuration parameter, Watchdog servers configurations

P

PAM, PAM Authentication
pcp configuration, Configuring pcp.conf
pcp_attach_node, pcp_attach_node
pcp_common_options, pcp_common_options
pcp_detach_node, pcp_detach_node
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_socket_dir configuration parameter, Connection Settings
pcp_stop_pgpool, pcp_stop_pgpool
pcp_watchdog_info, pcp_watchdog_info
pgpool, pgpool
Pgpool-II configuration, Configuring Pgpool-II
Pgpool-II user, The Pgpool-II User Account
pgpool.conf, Parameter Interaction via the Configuration File
pgpool_adm_pcp_attach_node, pgpool_adm_pcp_attach_node
pgpool_adm_pcp_detach_node, pgpool_adm_pcp_detach_node
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_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

R

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_size configuration parameter, Misc Configuration Parameters
replicate_select configuration parameter, Replication mode
replication_mode configuration parameter, Replication mode
replication_stop_on_mismatch configuration parameter, Replication mode
RESET, PGPOOL RESET
reset_query_list configuration parameter, Connection Pooling Settings

S

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_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
SIGHUP, Parameter Interaction via the Configuration File
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_key configuration parameter, SSL Settings
ssl_prefer_server_ciphers configuration parameter, SSL Settings
streaming replication mode, Running mode of Pgpool-II
syslog_facility configuration parameter, Where To Log
syslog_ident configuration parameter, Where To Log

T

trusted_servers configuration parameter, Upstream server connection

U

use_watchdog configuration parameter, Enable watchdog

W

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_de_escalation_command configuration parameter, Behaivor on escalation and de-escalation
wd_escalation_command configuration parameter, Behaivor on escalation and de-escalation
wd_heartbeat_deadtime configuration parameter, Lifecheck Heartbeat mode configuration
wd_heartbeat_keepalive configuration parameter, Lifecheck Heartbeat mode configuration
wd_heartbeat_port configuration parameter, Lifecheck Heartbeat mode configuration
wd_hostname configuration parameter, Watchdog communication
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_port configuration parameter, Watchdog communication
wd_priority configuration parameter, Life checking Pgpool-II
white_function_list configuration parameter, Load Balancing Settings
white_memqcache_table_list configuration parameter, Common configurations