item | value | description --------------------------------------+--------------------------------------------------+------------------------------------------------------------------ listen_addresses | * | host name(s) or IP address(es) to listen to port | 5432 | pgpool accepting port number socket_dir | /var/run/postgresql | pgpool socket directory pcp_port | 9898 | PCP port # to bind pcp_socket_dir | /var/run/postgresql | PCP socket directory enable_pool_hba | 1 | if true, use pool_hba.conf for client authentication pool_passwd | pool_passwd | file name of pool_passwd for md5 authentication authentication_timeout | 60 | maximum time in seconds to complete client authentication ssl | 1 | SSL support ssl_key | /etc/pgpool2/ssl/server.key | path to the SSL private key file ssl_cert | /etc/pgpool2/ssl/server.crt | path to the SSL public certificate file ssl_ca_cert | | path to a single PEM format file ssl_ca_cert_dir | | directory containing CA root certificate(s) num_init_children | 256 | # of children initially pre-forked max_pool | 4 | max # of connection pool per child child_life_time | 300 | if idle for this seconds, child exits child_max_connections | 0 | if max_connections received, chile exits connection_life_time | 0 | if idle for this seconds, connection closes client_idle_limit | 0 | if idle for this seconds, child connection closes log_destination | syslog | logging destination print_timestamp | 1 | if true print time stamp to each log line log_connections | 0 | if true, print incoming connections to the log log_hostname | 0 | if true, resolve hostname for ps and log print log_statement | 0 | if non 0, logs all SQL statements log_per_node_statement | 0 | if non 0, logs all SQL statements on each node log_standby_delay | none | how to log standby delay syslog_facility | LOCAL0 | syslog local faclity syslog_ident | pgpool | syslog program ident string debug_level | 0 | debug message level pid_file_name | /var/run/postgresql/pgpool.pid | path to pid file logdir | /var/log/postgresql | PgPool status file logging directory connection_cache | 1 | if true, cache connection pool reset_query_list | ABORT; DISCARD ALL | queries issued at the end of session replication_mode | 1 | non 0 if operating in replication mode replicate_select | 0 | non 0 if SELECT statement is replicated insert_lock | 1 | insert lock lobj_lock_table | | table name used for large object replication control replication_stop_on_mismatch | 1 | stop replication mode on fatal error failover_if_affected_tuples_mismatch | 1 | failover if affected tuples are mismatch load_balance_mode | 1 | non 0 if operating in load balancing mode ignore_leading_white_space | 1 | ignore leading white spaces white_function_list | | functions those do not write to database black_function_list | nextval,setval | functions those write to database master_slave_mode | 0 | if true, operate in master/slave mode master_slave_sub_mode | slony | master/slave sub mode sr_check_period | 0 | sr check period sr_check_user | nobody | sr check user delay_threshold | 0 | standby delay threshold follow_master_command | | follow master command parallel_mode | 0 | if non 0, run in parallel query mode enable_query_cache | 0 | if non 0, use query cache pgpool2_hostname | node1 | pgpool2 hostname system_db_hostname | localhost | system DB hostname system_db_port | 5432 | system DB port number system_db_dbname | pgpool | system DB name system_db_schema | pgpool_catalog | system DB schema name system_db_user | pgpool | user name to access system DB health_check_period | 0 | health check period health_check_timeout | 10 | health check timeout health_check_user | pgpool | health check user health_check_max_retries | 0 | health check max retries health_check_retry_delay | 1 | health check retry delay failover_command | | failover command failback_command | | failback command fail_over_on_backend_error | 1 | fail over on backend error recovery_user | postgres | online recovery user recovery_1st_stage_command | stage_one.sh | execute a command in first stage. recovery_2nd_stage_command | stage_two.sh | execute a command in second stage. recovery_timeout | 10 | max time in seconds to wait for the recovering node's postmaster search_primary_node_timeout | 10 | max time in seconds to search for primary node after failover client_idle_limit_in_recovery | 1 | if idle for this seconds, child connection closes in recovery 2n relcache_expire | 0 | relation cache expiration time in seconds relcache_size | 256 | number of relation cache entry check_temp_table | 1 | enable temporary table check parallel_mode | 0 | if non 0, run in parallel query mode enable_query_cache | 0 | if non 0, use query cache pgpool2_hostname | node1 | pgpool2 hostname system_db_hostname | localhost | system DB hostname system_db_port | 5432 | system DB port number system_db_dbname | pgpool | system DB name system_db_schema | pgpool_catalog | system DB schema name system_db_user | pgpool | user name to access system DB use_watchdog | 1 | non 0 if operating in use_watchdog wd_lifecheck_method | heartbeat | method of watchdog lifecheck clear_memqcache_on_escalation | 1 | If true, clear all the query caches in shared memory when escala wd_escalation_command | | command executed when escalation occurs trusted_servers | | upper server list to observe connection delegate_IP | | delegate IP address of master pgpool wd_hostname | node1 | Host name or IP address of this watchdog wd_port | 9000 | watchdog port number wd_interval | 3 | life check interval (second) ping_path | /bin | path to ping command ifconfig_path | /usr/local/bin | path to ifconfig command if_up_cmd | pgp_ifconfig eth1:db $_IP_$ 255.255.255.255 up | virtual interface up command with full parameters if_down_cmd | pgp_ifconfig eth1:db $_IP_$ 255.255.255.255 down | virtual interface down command with full parameters arping_path | /usr/bin | path to arping command arping_cmd | sudo /usr/sbin/arpsend -U -i $_IP_$ -c1 eth1:db | send ARP REQUESTi to neighbour host wd_heartbeat_port | 9694 | port number for receiving heartbeat signal wd_heartbeat_keepalive | 2 | interval time of sending heartbeat siganl (sec) wd_heartbeat_deadtime | 10 | deadtime interval for heartbeat siganl (sec) wd_life_point | 3 | retry times of life check wd_lifecheck_query | SELECT 1 | lifecheck query to pgpool from watchdog wd_lifecheck_dbname | template1 | database name connected for lifecheck wd_lifecheck_user | nobody | watchdog user monitoring pgpools in lifecheck wd_lifecheck_password | | password for watchdog user in lifecheck memory_cache_enabled | 0 | If true, use the memory cache functionality, false by default memqcache_method | shmem | Cache store method. either shmem(shared memory) or Memcached. sh memqcache_memcached_host | localhost | Memcached host name. Mandatory if memqcache_method=memcached memqcache_memcached_port | 11211 | Memcached port number. Mondatory if memqcache_method=memcached memqcache_total_size | 67108864 | Total memory size in bytes for storing memory cache. Mandatory i memqcache_max_num_cache | 1000000 | Total number of cache entries memqcache_expire | 0 | Memory cache entry life time specified in seconds. 60 by default memqcache_auto_cache_invalidation | 1 | If true, invalidation of query cache is triggered by correspondi memqcache_maxcache | 409600 | Maximum SELECT result size in bytes memqcache_cache_block_size | 1048576 | Cache block size in bytes. 8192 by default memqcache_cache_oiddir | /var/log/pgpool/oiddir | Tempory work directory to record table oids memqcache_stats_start_time | Thu Jan 1 01:00:00 1970 +| Start time of query cache stats | | memqcache_no_cache_hits | 0 | Number of SELECTs not hitting query cache memqcache_cache_hits | 0 | Number of SELECTs hitting query cache white_memqcache_table_list | | tables to memqcache black_memqcache_table_list | | tables not to memqcache backend_hostname0 | | backend #0 hostname backend_port0 | 5432 | backend #0 port number backend_weight0 | 1.000000 | weight of backend #0 backend_data_directory0 | /data/postgresql/dbf | data directory for backend #0 backend_status0 | 2 | status of backend #0 standby_delay0 | 0 | standby delay of backend #0 backend_flag0 | ALLOW_TO_FAILOVER | backend #0 flag backend_hostname1 | | backend #1 hostname backend_port1 | 5432 | backend #1 port number backend_weight1 | 0.000000 | weight of backend #1 backend_data_directory1 | /data/postgresql/dbf | data directory for backend #1 backend_status1 | 2 | status of backend #1 standby_delay1 | 0 | standby delay of backend #1 backend_flag1 | ALLOW_TO_FAILOVER | backend #1 flag other_pgpool_hostname0 | node2 | pgpool #0 hostname other_pgpool_port0 | 5432 | pgpool #0 port number other_pgpool_wd_port0 | 9000 | pgpool #0 watchdog port number heartbeat_device0 | | name of NIC device #0 for sending hearbeat heartbeat_destination0 | node2 | destination host for sending heartbeat using NIC device 0 heartbeat_destination_port0 | 9694 | destination port for sending heartbeat using NIC device 0 (141 rows)