Index

Symbols

.pcppass, PCP password file

A

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

B

backend_application_name configuration parameter, Backend Data Settings
backend_clustering_mode configuration parameter, Clustering mode
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
backup, Backing up PostgreSQL database
bison, Requirements

C

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

D

database_redirect_preference_list configuration parameter, Load Balancing Settings
delay_threshold configuration parameter, Streaming Replication Check
delay_threshold_by_time 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
dml_adaptive_object_relationship_list configuration parameter, Load Balancing Settings
dynamic process management, Clustering mode of Pgpool-II

E

enable_consensus_with_half_votes configuration parameter, Controlling the Failover behavior
enable_pool_hba configuration parameter, Authentication Settings
enable_shared_relcache configuration parameter, Misc Configuration Parameters

F

failback_command configuration parameter, Failover and Failback Settings
failover_command configuration parameter, Failover and Failback Settings
failover_if_affected_tuples_mismatch configuration parameter, Native replication mode
failover_on_backend_error configuration parameter, Failover and Failback Settings
failover_on_backend_shutdown 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_primary_command configuration parameter, Failover and Failback Settings

G

GSSAPI, GSSAPI Authentication

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_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

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, Native replication mode
installation, Installation of Pgpool-II

L

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, Clustering 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_pcp_processes configuration parameter, What 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

M

main replica mode, Clustering mode of Pgpool-II
make, Requirements
max_pool configuration parameter, Connection Pooling Settings
max_spare_children configuration parameter, Process Management
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
min_spare_children configuration parameter, Process Management

N

native replication mode, Clustering mode of Pgpool-II
notice_per_node_statement configuration parameter, What To Log
num_init_children configuration parameter, Connection Settings

O

online recovery, Online Recovery

P

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, Virtual IP control
pool_hba.conf, The pool_hba.conf File
pool_passwd configuration parameter, Authentication Settings
port configuration parameter, Connection Settings
prefer_lower_delay_standby configuration parameter, Streaming Replication Check
primary_routing_query_pattern_list configuration parameter, Load Balancing Settings
process_management_mode configuration parameter, Process Management
process_management_strategy configuration parameter, Process Management

Q

quarantine, Controlling the Failover behavior
quorum, Behaviour on escalation and de-escalation, Controlling the Failover behavior

R

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

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_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, Clustering mode of Pgpool-II
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
static process management, Clustering mode of Pgpool-II
streaming replication mode, Clustering 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
trusted_server_command configuration parameter, Upstream server connection

U

unix_socket_directories configuration parameter, Connection Settings
unix_socket_group configuration parameter, Connection Settings
unix_socket_permissions configuration parameter, Connection Settings
user_redirect_preference_list configuration parameter, Load Balancing Settings
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_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_lost_node_removal_timeout configuration parameter, Controlling the watchdog cluster membership
wd_monitoring_interfaces_list configuration parameter, Life checking Pgpool-II
wd_no_show_node_removal_timeout configuration parameter, Controlling the watchdog cluster membership
wd_portX configuration parameter, Watchdog communication
wd_priority configuration parameter, Life checking Pgpool-II
wd_remove_shutdown_nodes configuration parameter, Controlling the watchdog cluster membership
write_function_list configuration parameter, Load Balancing Settings

Y

yacc, Requirements