# - Pool size -
num_init_children = 32
# Number of pools # (change requires restart) max_pool = 4
# Number of connections per pool # (change requires restart)
# - Life time -
child_life_time = 300
# Pool exits after being idle for this many seconds child_max_connections = 0
# Pool exits after receiving that many connections # 0 means no exit connection_life_time = 0
# Connection to backend closes after being idle for this many seconds # 0 means no close client_idle_limit = 0
# Client is disconnected after being idle for that many seconds # (even inside an explicit transactions!) # 0 means no disconnection
#------------------------------------------------------------------------------ # LOGS
#------------------------------------------------------------------------------
# - Where to log -
log_destination = 'stderr'
# Where to log
# Valid values are combinations of stderr, # and syslog. Default to stderr.
# - What to log -
log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.
log_connections = off
# Log connections log_hostname = off
# Hostname will be shown in ps status # and in logs if connections are logged log_statement = off
# Log all statements log_per_node_statement = off
# Log all statements
# with node and backend informations
log_standby_delay = 'if_over_threshold'
# Log standby delay
# Valid values are combinations of always, # if_over_threshold, none
# - Syslog specific -
syslog_facility = 'LOCAL0'
# Syslog local facility. Default to LOCAL0 syslog_ident = 'pgpool'
# Syslog program identification string # Default to 'pgpool'
# - Debug -
debug_level = 0
# Debug message verbosity level
# 0 means no message, 1 or more mean verbose
#log_error_verbosity = default # terse, default, or verbose messages
#client_min_messages = notice # values in order of decreasing detail: # debug5 # debug4 # debug3 # debug2 # debug1 # log # notice # warning # error
#log_min_messages = warning # values in order of decreasing detail: # debug5 # debug4 # debug3 # debug2 # debug1 # info # notice # warning # error # log # fatal # panic
#------------------------------------------------------------------------------ # FILE LOCATIONS
#------------------------------------------------------------------------------
pid_file_name = '/usr/local/pgpool/pgpool.pid'
# PID file name
# (change requires restart) logdir = '/tmp'
# Directory of pgPool status file # (change requires restart)
#------------------------------------------------------------------------------ # CONNECTION POOLING
#------------------------------------------------------------------------------
connection_cache = on
# Activate connection pools # (change requires restart)
# Semicolon separated list of queries # to be issued at the end of a session # The default is for 8.3 and later reset_query_list = 'ABORT; DISCARD ALL'
# The following one is for 8.2 and before #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
#------------------------------------------------------------------------------ # REPLICATION MODE
#------------------------------------------------------------------------------
replication_mode = off
# Activate replication mode # (change requires restart) replicate_select = off
# Replicate SELECT statements # when in replication mode
# replicate_select is higher priority than # load_balance_mode.
insert_lock = off
# Automatically locks a dummy row or a table # with INSERT statements to keep SERIAL data # consistency
# Without SERIAL, no lock will be issued lobj_lock_table = ''
# When rewriting lo_creat command in # replication mode, specify table name to # lock
# - Degenerate handling -
replication_stop_on_mismatch = off
# On disagreement with the packet kind # sent from backend, degenerate the node # which is most likely \ # If off, just force to exit this session
failover_if_affected_tuples_mismatch = off
# On disagreement with the number of affected # tuples in UPDATE/DELETE queries, then # degenerate the node which is most likely # \
# If off, just abort the transaction to # keep the consistency
#------------------------------------------------------------------------------ # LOAD BALANCING MODE
#------------------------------------------------------------------------------
load_balance_mode = on
# Activate load balancing mode # (change requires restart) ignore_leading_white_space = on
# Ignore leading white spaces of each query white_function_list = ''
# Comma separated list of function names # that don't write to database # Regexp are accepted black_function_list = 'currval,lastval,nextval,setval'
# Comma separated list of function names # that write to database # Regexp are accepted
database_redirect_preference_list = ''
app_name_redirect_preference_list = ''
# comma separated list of pairs of app name and node id. # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby' # valid for streaming replicaton mode only.
# comma separated list of pairs of database and node id. # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2' # valid for streaming replicaton mode only.
allow_sql_comments = off
#------------------------------------------------------------------------------ # MASTER/SLAVE MODE
#------------------------------------------------------------------------------
# if on, ignore SQL comments when judging if load balance or # query cache is possible.
# If off, SQL comments effectively prevent the judgment # (pre 3.4 behavior).