pgpool2.git / summary / log / commit / refs
commit d63c7dd985b552d0f01f249bded6140eb80ac671
Author: Yugo Nagata <nagata@sraoss.co.jp>
Date: Tue May 13 07:38:45 2014 +0000
Remove a unnecessary file
src/sample/pgpool.conf | 586 -------------------------------------------------
1 file changed, 586 deletions(-)
diff --git a/src/sample/pgpool.conf b/src/sample/pgpool.conf
deleted file mode 100644
index e43e2f127..000000000
--- a/src/sample/pgpool.conf
+++ /dev/null
@@ -1,586 +0,0 @@
-# ----------------------------
-# pgPool-II configuration file
-# ----------------------------
-#
-# This file consists of lines of the form:
-#
-# name = value
-#
-# Whitespace may be used. Comments are introduced with "#" anywhere on a line.
-# The complete list of parameter names and allowed values can be found in the
-# pgPool-II documentation.
-#
-# This file is read on server startup and when the server receives a SIGHUP
-# signal. If you edit the file on a running system, you have to SIGHUP the
-# server for the changes to take effect, or use "pgpool reload". Some
-# parameters, which are marked below, require a server shutdown and restart to
-# take effect.
-#
-
-
-#------------------------------------------------------------------------------
-# CONNECTIONS
-#------------------------------------------------------------------------------
-
-# - 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)
-
-# - Backend Connection Settings -
-
-backend_hostname0 = 'vm1'
- # Host name or IP address to connect to for backend 0
-backend_port0 = 5432
- # Port number for backend 0
-backend_weight0 = 1
- # Weight for backend 0 (only in load balancing mode)
-backend_data_directory0 = '/usr/local/pgsql/data'
- # Data directory for backend 0
-backend_flag0 = 'ALLOW_TO_FAILOVER'
- # Controls various backend behavior
- # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
-backend_hostname1 = 'vm2'
-backend_port1 = 5433
-backend_weight1 = 1
-backend_data_directory1 = '/usr/local/pgsql/data'
-backend_flag1 = 'ALLOW_TO_FAILOVER'
-
-# - Authentication -
-
-enable_pool_hba = off
- # Use pool_hba.conf for client authentication
-authentication_timeout = 60
- # Delay in seconds to complete client authentication
- # 0 means no timeout.
-
-# - SSL Connections -
-
-ssl = off
- # Enable SSL support
- # (change requires restart)
-#ssl_key = './server.key'
- # Path to the SSL private key file
- # (change requires restart)
-#ssl_cert = './server.cert'
- # Path to the SSL public certificate file
- # (change requires restart)
-#ssl_ca_cert = ''
- # Path to a single PEM format file
- # containing CA root certificate(s)
- # (change requires restart)
-#ssl_ca_cert_dir = ''
- # Directory containing CA root certificate(s)
- # (change requires restart)
-
-
-#------------------------------------------------------------------------------
-# POOLS
-#------------------------------------------------------------------------------
-
-# - 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 -
-
-print_timestamp = on
- # Print timestamp on each line
- # (change requires restart)
-print_user = off
- # Print user name on each line
- # (change requires restart)
-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 = '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'
-
-# - 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 = './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 or parallel mode
- # replicate_select is higher priority than
- # load_balance_mode.
-
-insert_lock = on
- # 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 "minority"
- # 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
- # "minority".
- # If off, just abort the transaction to
- # keep the consistency
-
-
-#------------------------------------------------------------------------------
-# LOAD BALANCING MODE
-#------------------------------------------------------------------------------
-
-load_balance_mode = off
- # 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 = 'nextval,setval'
- # Comma separated list of function names
- # that write to database
- # Regexp are accepted
-
-
-#------------------------------------------------------------------------------
-# MASTER/SLAVE MODE
-#------------------------------------------------------------------------------
-
-master_slave_mode = off
- # Activate master/slave mode
- # (change requires restart)
-master_slave_sub_mode = 'slony'
- # Master/slave sub mode
- # Valid values are combinations slony or
- # stream. Default is slony.
- # (change requires restart)
-
-# - Streaming -
-
-sr_check_period = 0
- # Streaming replication check period
- # Disabled (0) by default
-sr_check_user = 'nobody'
- # Streaming replication check user
- # This is necessary even if you disable
- # streaming replication delay check with
- # sr_check_period = 0
-sr_check_password = ''
- # Password for streaming replication check user
-delay_threshold = 0
- # Threshold before not dispatching query to standby node
- # Unit is in bytes
- # Disabled (0) by default
-
-# - Special commands -
-
-follow_master_command = ''
- # Executes this command after master failover
- # Special values:
- # %d = node id
- # %h = host name
- # %p = port number
- # %D = database cluster path
- # %m = new master node id
- # %H = hostname of the new master node
- # %M = old master node id
- # %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
- # %% = '%' character
-
-
-#------------------------------------------------------------------------------
-# PARALLEL MODE
-#------------------------------------------------------------------------------
-
-parallel_mode = off
- # Activates parallel query mode
- # (change requires restart)
-pgpool2_hostname = 'vm1'
- # Set pgpool2 hostname
- # (change requires restart)
-
-# - System DB info -
-
-system_db_hostname = 'localhost'
- # (change requires restart)
-system_db_port = 5432
- # (change requires restart)
-system_db_dbname = 'pgpool'
- # (change requires restart)
-system_db_schema = 'pgpool_catalog'
- # (change requires restart)
-system_db_user = 'pgpool'
- # (change requires restart)
-system_db_password = ''
- # (change requires restart)
-
-
-#------------------------------------------------------------------------------
-# HEALTH CHECK
-#------------------------------------------------------------------------------
-
-health_check_period = 0
- # Health check period
- # Disabled (0) by default
-health_check_timeout = 20
- # Health check timeout
- # 0 means no timeout
-health_check_user = 'nobody'
- # Health check user
-health_check_password = ''
- # Password for health check user
-health_check_max_retries = 0
- # Maximum number of times to retry a failed health check before giving up.
-health_check_retry_delay = 1
- # Amount of time to wait (in seconds) between retries.
-
-
-#------------------------------------------------------------------------------
-# FAILOVER AND FAILBACK
-#------------------------------------------------------------------------------
-
-failover_command = ''
- # Executes this command at failover
- # Special values:
- # %d = node id
- # %h = host name
- # %p = port number
- # %D = database cluster path
- # %m = new master node id
- # %H = hostname of the new master node
- # %M = old master node id
- # %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
- # %% = '%' character
-failback_command = ''
- # Executes this command at failback.
- # Special values:
- # %d = node id
- # %h = host name
- # %p = port number
- # %D = database cluster path
- # %m = new master node id
- # %H = hostname of the new master node
- # %M = old master node id
- # %P = old primary node id
- # %r = new master port number
- # %R = new master database cluster path
- # %% = '%' character
-
-fail_over_on_backend_error = on
- # Initiates failover when reading/writing to the
- # backend communication socket fails
- # If set to off, pgpool will report an
- # error and disconnect the session.
-
-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_user = 'nobody'
- # Online recovery user
-recovery_password = ''
- # Online recovery password
-recovery_1st_stage_command = ''
- # Executes a command in first stage
-recovery_2nd_stage_command = ''
- # Executes a command in second stage
-recovery_timeout = 90
- # Timeout in seconds to wait for the
- # recovering node's postmaster to start up
- # 0 means no wait
-client_idle_limit_in_recovery = 0
- # Client is disconnected after being idle
- # for that many seconds in the second stage
- # of online recovery
- # 0 means no disconnection
- # -1 means immediate disconnection
-
-
-#------------------------------------------------------------------------------
-# WATCHDOG
-#------------------------------------------------------------------------------
-use_watchdog = on
- # Activates watchdog
-trusted_servers = '192.168.122.1'
- # trusted server list which are used
- # to confirm network connection
- # (hostA,hostB,hostC,...)
-delegate_IP = '192.168.122.80'
- # delegate IP address
-wd_hostname = 'vm1'
- # Host name or IP address of this watchdog
-wd_port = 9000
- # port number for watchdog service
-wd_interval = 10
- # lifecheck interval (sec) > 0
-ping_path = '/bin'
- # ping command path
-ifconfig_path = '/sbin'
- # ifconfig command path
-if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
- # startup delegate IP command
-if_down_cmd = 'ifconfig eth0:0 down'
- # shutdown delegate IP command
-wd_life_point = 3
- # lifecheck retry times
-wd_lifecheck_query = 'SELECT 1'
- # lifecheck query to pgpool from watchdog
-# Other pgpool Connection Settings
-
-other_pgpool_hostname0 = 'vm2'
- # Host name or IP address to connect to for other pgpool 0
-other_pgpool_port0 = 9999
- # Port number for othet pgpool 0
-other_wd_port0 = 9000
- # Port number for othet watchdog 0
-#other_pgpool_hostname1 = 'vm1'
-#other_pgpool_port1 = 9999
-#other_wd_port1 = 9000
-
-#------------------------------------------------------------------------------
-# OTHERS
-#------------------------------------------------------------------------------
-relcache_expire = 0
- # Life time of relation cache in seconds.
- # 0 means no cache expiration(the default).
- # The relation cache is used for cache the
- # query result against PostgreSQL system
- # catalog to obtain various information
- # including table structures or if it's a
- # temporary table or not. The cache is
- # maintained in a pgpool child local memory
- # and being kept as long as it survives.
- # If someone modify the table by using
- # ALTER TABLE or some such, the relcache is
- # not consistent anymore.
- # For this purpose, cache_expiration
- # controls the life time of the cache.
-
-relcache_size = 256
- # Number of relation cache
- # entry. If you see frequently:
- # "pool_search_relcache: cache replacement happend"
- # in the pgpool log, you might want to increate this number.
-
-check_temp_table = on
- # If on, enable temporary table check in SELECT statements.
- # This initiates queries against system catalog of primary/master
- # thus increases load of master.
- # If you are absolutely sure that your system never uses temporary tables
- # and you want to save access to primary/master, you could turn this off.
- # Default is on.
-
-
-#------------------------------------------------------------------------------
-# ON MEMORY QUERY MEMORY CACHE
-#------------------------------------------------------------------------------
-# If on, use the memory cache functionality, off by default
-memory_cache_enabled = off
-
-# Cache storage method. either 'shmem'(shared memory) or 'memcached'. 'shmem' by default
-memqcache_method = 'shmem'
-
-# Memcached host name or IP address. Mandatory if memqcache_method = 'memcached'.
-# Defaults to localhost
-memqcache_memcached_host = 'localhost'
-
-# Memcached port number. Mondatory if memqcache_method = 'memcached'.
-# Defaults to 11211
-memqcache_memcached_port = 11211
-
-# Total memory size in bytes for storing memory cache. Mandatory if memqcache_method = 'shmem'.
-# Defaults to 64MB.
-memqcache_total_size = 67108864
-
-# Total number of cache entries. Mandatory if memqcache_method = 'shmem'.
-# Each cache entry consumes 48 bytes on shared memory. Defaults to 1,000,000(45.8MB).
-memqcache_max_num_cache = 1000000
-
-# Memory cache entry life time specified in seconds.
-# 0 means infinite life time. 0 by default.
-memqcache_expire = 0
-
-# If on, invalidation of query cache is triggered by corresponding
-# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered
-# by memqcache_expire. on by default.
-memqcache_auto_cache_invalidation = on
-
-# Maximum SELECT result size in bytes.
-# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.
-memqcache_maxcache = 409600
-
-# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.
-# Defaults to 1MB.
-memqcache_cache_block_size = 1048576
-
-# Temporary work directory to record table oids
-memqcache_oiddir = '/var/log/pgpool/oiddir'
-
-white_memqcache_table_list = ''
- # Comma separated list of table names to memcache
- # that don't write to database
- # Regexp are accepted
-black_memqcache_table_list = ''
- # Comma separated list of table names not to memcache
- # that don't write to database
- # Regexp are accepted
[parent: e5725864c33a]