# - pgpool Connection Settings -

listen_addresses = '*'
                                   # Host name or IP address to listen on:
                                   # '*' for all, '' for no TCP/IP connections
                                   # (change requires restart)
port = 9999
                                   # Port number
                                   # (change requires restart)
socket_dir = '/tmp'
                                   # Unix domain socket path
                                   # The Debian package defaults to
                                   # /var/run/postgresql
                                   # (change requires restart)

# - pgpool Communication Manager Connection Settings -

pcp_listen_addresses = '*'
                                   # Host name or IP address for pcp process to listen on:
                                   # '*' for all, '' for no TCP/IP connections
                                   # (change requires restart)
pcp_port = 9898
                                   # Port number for pcp
                                   # (change requires restart)
pcp_socket_dir = '/tmp'
                                   # Unix domain socket path for pcp
                                   # The Debian package defaults to
                                   # /var/run/postgresql
                                   # (change requires restart)

# - Authentication -

authentication_timeout = 60
                                   # Delay in seconds to complete client authentication
                                   # 0 means no timeout.

#------------------------------------------------------------------------------
# HEALTH CHECK
#------------------------------------------------------------------------------

health_check_timeout = 20
                                   # Health check timeout
                                   # 0 means no timeout

connect_timeout = 10000
                                   # Timeout value in milliseconds before giving up to connect to backend.
                                                               # Default is 10000 ms (10 second). Flaky network user may want to increase
                                                               # the value. 0 means no timeout.
                                                               # Note that this value is not only used for health check,
                                                               # but also for ordinary conection to backend.

search_primary_node_timeout = 10
                                   # Timeout in seconds to search for the
                                   # primary node when a failover occurs.
                                   # 0 means no timeout, keep searching
                                   # for a primary node forever.


#------------------------------------------------------------------------------
# ONLINE RECOVERY
#------------------------------------------------------------------------------

recovery_timeout = 90
                                   # Timeout in seconds to wait for the
                                   # recovering node's postmaster to start up
                                   # 0 means no wait

#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------

logdir = '/var/log/pgpool'
                                   # Directory of pgPool status file
                                   # (change requires restart)

#------------------------------------------------------------------------------
# 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 = on
#log_connections = off
                                   # Log connections
log_hostname = on
#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 = 'none'
                                   # 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'

#------------------------------------------------------------------------------
# POOLS
#------------------------------------------------------------------------------

# - Concurrent session and pool size -

num_init_children = 5
                                   # Number of concurrent sessions allowed
                                   # (change requires restart)
max_pool = 4
                                   # Number of connection pool caches per connection
                                   # (change requires restart)

#------------------------------------------------------------------------------
# IN MEMORY QUERY MEMORY CACHE
#------------------------------------------------------------------------------
memory_cache_enabled = off
                                   # If on, use the memory cache functionality, off by default
memqcache_method = 'shmem'
                                   # Cache storage method. either 'shmem'(shared memory) or
                                   # 'memcached'. 'shmem' by default
                                   # (change requires restart)

# - SSL Connections -

ssl = on

# - SSL Connections -

ssl_key = '/etc/pki/tls/certs/cen05dev.xen.wbcd.pl-pgsql.pem'
#ssl_key = './server.key'
                                   # Path to the SSL private key file
                                   # (change requires restart)
ssl_cert = '/etc/pki/tls/certs/cen05dev.xen.wbcd.pl-pgsql.pem'
#ssl_cert = './server.cert'
                                   # Path to the SSL public certificate file
                                   # (change requires restart)
ssl_ca_cert = '/etc/pki/tls/certs/ca-bundle.crt'
#ssl_ca_cert = ''
                                   # Path to a single PEM format file
                                   # containing CA root certificate(s)
                                   # (change requires restart)
ssl_ca_cert_dir = '/etc/pki/tls/certs/'
#ssl_ca_cert_dir = ''
                                   # Directory containing CA root certificate(s)
                                   # (change requires restart)

# - SSL Connections -

# - SSL Connections -

# - SSL Connections -

# - SSL Connections -