[pgpool-general: 3016] Re: Pgpool Up but disconnected estate 1 never finish
Luis Marin
luismarinaray at gmail.com
Wed Jul 9 23:48:02 JST 2014
For future reference,
I have done nothing, just request a connection,
psql -h 192.168.1.101 -p 9999 -l
and I get connected, now both servers are in up state every one with its
role
also important fix any error message that you got in the log.
Thanks
On Mon, Jul 7, 2014 at 9:22 PM, Luis Marin <luismarinaray at gmail.com> wrote:
> Hi,
>
> Please advise me,
>
> I'm following instructions from :
>
>
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> but finally, appears something like this in Pgpool admin
>
> Node0 Backend Info:
>
> Node 0 port Up. Disconnect. Running as primary server postgresql Up
> Node 1 port Up. Disconnect. Running as standby server postgresql Up
>
> Node1 Backend Info:
>
> Node 0 port Up. Disconnect. Running as standby server postgresql Up
> Node 1 port Up. Disconnect. Running as primary server postgresql Up
>
> I've checked:
>
> 1. ) Postgresql is running ok in master/slave mode using streaming
> replication. I'm attaching extract from postgresql.conf master server
>
> 2.) I've run in console pcp_node_info 5 localhost 9898 postgres postgres 0
> (in master)
>
> 10.100.10.171 5432 1 0.500000
>
> 3.) from pgpooladmin I got :
>
> Log, no error messages, except;
>
> wd_IP_up: ifconfig up failed related to arping -U invalid option
>
> I'm also attaching extract from pgpool.conf file,
>
> I've setup anything wrong ? what am'I not seeing ? [?]
>
> Thanks for your ideas and support
>
> pgpool.conf
> -----------
> # ----------------------------
> # 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_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 = '10.100.10.171'
> backend_port0 = 5432 # Port number for backend 0
> backend_weight0 = 1
> backend_data_directory0 = '/var/lib/postgresql/9.3/main/'
> backend_flag0 = 'ALLOW_TO_FAILOVER'
> backend_hostname1 = '10.100.10.173'
> backend_port1 = 5432
> backend_weight1 = 1
> backend_data_directory1 = '/var/lib/postgresql/9.3/main/'
> backend_flag1 = 'ALLOW_TO_FAILOVER'
>
> # - Authentication -
>
> enable_pool_hba = off
> # Use pool_hba.conf for client
> authentication
> pool_passwd = ''
> # File name of pool_passwd for md5
> authentication.
> # "" disables pool_passwd.
> # (change requires restart)
> 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)
>
> 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
>
>
>
> #------------------------------------------------------------------------------
> # FILE LOCATIONS
>
> #------------------------------------------------------------------------------
>
> pid_file_name = '/var/run/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 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 = on
> # Activate load balancing mode (off)
> # (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 = on
> # Activate master/slave mode (off)
> # (change requires restart)
> master_slave_sub_mode = 'stream'
> # Master/slave sub mode (slony)
> # 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 = 'postgres'
> # Streaming replication check user
> # This is necessary even if you disable
> # streaming replication delay check with
> # sr_check_period = 0
> sr_check_password = 'postgres'
> # 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 = ''
> # 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 = 5
> # Health check period
> # Disabled (0) by default
> health_check_timeout = 0
> # Health check timeout
> # 0 means no timeout
> health_check_user = 'postgres'
> # Health check user (nobody)
> 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 = '/usr/local/etc/failover.sh %d %P %H %R'
> # 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 = 'postgres'
> # Online recovery user
> recovery_password = 'postgres'
> # Online recovery password
> recovery_1st_stage_command = 'recovery_1st_stage'
> # 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
>
> #------------------------------------------------------------------------------
>
> # - Enabling -
>
> use_watchdog = on
> # Activates watchdog (off)
> # (change requires restart)
>
> # -Connection to up stream servers -
>
> trusted_servers = ''
> # trusted server list which are used
> # to confirm network connection
> # (hostA,hostB,hostC,...)
> # (change requires restart)
> ping_path = '/bin'
> # ping command path
> # (change requires restart)
>
> # - Watchdog communication Settings -
>
> wd_hostname = '10.100.10.171'
> # Host name or IP address of this
> watchdog
> # (change requires restart)
> wd_port = 9000
> # port number for watchdog service
> # (change requires restart)
> wd_authkey = ''
> # Authentication key for watchdog
> communication
> # (change requires restart)
>
> # - Virtual IP control Setting -
>
> delegate_IP = '192.168.1.101'
> # delegate IP address
> # If this is empty, virtual IP never
> bring up.
> # (change requires restart)
> ifconfig_path = '/home/www-data/sbin'
> # ifconfig command path
> # (change requires restart)
> if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
> # startup delegate IP command
> # (change requires restart)
> if_down_cmd = 'ifconfig eth0:0 down'
> # shutdown delegate IP command
> # (change requires restart)
>
> arping_path = '/home/www-data/sbin' # arping command path
> # (change requires restart)
>
> arping_cmd = 'arping -U $_IP_$ -w 1'
> # arping command
> # (change requires restart)
>
> # - Behaivor on escalation Setting -
>
> clear_memqcache_on_escalation = on
> # Clear all the query cache on shared
> memory
> # when standby pgpool escalate to
> active pgpool
> # (= virtual IP holder).
> # This should be off if client
> connects to pgpool
> # not using virtual IP.
> # (change requires restart)
> wd_escalation_command = ''
> # Executes this command at escalation
> on new active pgpool.
> # (change requires restart)
>
> # - Lifecheck Setting -
>
> # -- common --
>
> wd_lifecheck_method = 'heartbeat'
> # Method of watchdog lifecheck
> ('heartbeat' or 'query')
> # (change requires restart)
> wd_interval = 3
> # lifecheck interval (sec) > 0 (10)
> # (change requires restart)
>
> # -- heartbeat mode --
>
> wd_heartbeat_port = 9694
> # Port number for receiving heartbeat
> signal
> # (change requires restart)
> wd_heartbeat_keepalive = 2
> # Interval time of sending heartbeat
> signal (sec)
> # (change requires restart)
> wd_heartbeat_deadtime = 30
> # Deadtime interval for heartbeat
> signal (sec)
> # (change requires restart)
> heartbeat_destination0 = '10.100.10.173'
> # Host name or IP address of
> destination 0
> # for sending heartbeat signal.
> # (change requires restart)
> heartbeat_destination_port0 = 9694
> # Port number of destination 0 for
> sending
> # heartbeat signal. Usually this is the
> # same as wd_heartbeat_port.
> # (change requires restart)
> heartbeat_device0 = ''
> # Name of NIC device (such like 'eth0')
> # used for sending/receiving heartbeat
> # signal to/from destination 0.
> # This works only when this is not
> empty
> # and pgpool has root privilege.
> # (change requires restart)
>
> #heartbeat_destination1 = 'host0_ip2'
> #heartbeat_destination_port1 = 9694
> #heartbeat_device1 = ''
>
> # -- query mode --
>
> wd_life_point = 3
> # lifecheck retry times
> # (change requires restart)
> wd_lifecheck_query = 'SELECT 1'
> # lifecheck query to pgpool from
> watchdog
> # (change requires restart)
> wd_lifecheck_dbname = 'template1'
> # Database name connected for lifecheck
> # (change requires restart)
> wd_lifecheck_user = 'nobody'
> # watchdog user monitoring pgpools in
> lifecheck
> # (change requires restart)
> wd_lifecheck_password = ''
> # Password for watchdog user in
> lifecheck
> # (change requires restart)
>
> # - Other pgpool Connection Settings -
>
> other_pgpool_hostname0 = '10.100.10.173'
> # Host name or IP address to connect
> to for other pgpool 0
> # (change requires restart)
> other_pgpool_port0 = 9999
> # Port number for othet pgpool 0
> # (change requires restart)
> other_wd_port0 = 9000
> # Port number for othet watchdog 0
> # (change requires restart)
> #other_pgpool_hostname1 = 'host1'
> #other_pgpool_port1 = 5432
> #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
>
> #------------------------------------------------------------------------------
> 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)
> memqcache_memcached_host = 'localhost'
> # Memcached host name or IP address.
> Mandatory if
> # memqcache_method = 'memcached'.
> # Defaults to localhost.
> # (change requires restart)
> memqcache_memcached_port = 11211
> # Memcached port number. Mondatory if
> memqcache_method = 'memcached'.
> # Defaults to 11211.
> # (change requires restart)
> memqcache_total_size = 67108864
> # Total memory size in bytes for
> storing memory cache.
> # Mandatory if memqcache_method =
> 'shmem'.
> # Defaults to 64MB.
> # (change requires restart)
> memqcache_max_num_cache = 1000000
> # 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).
> # (change requires restart)
> memqcache_expire = 0
> # Memory cache entry life time
> specified in seconds.
> # 0 means infinite life time. 0 by
> default.
> # (change requires restart)
> memqcache_auto_cache_invalidation = on
> # 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.
> # (change requires restart)
> memqcache_maxcache = 409600
> # Maximum SELECT result size in bytes.
> # Must be smaller than
> memqcache_cache_block_size. Defaults to 400KB.
> # (change requires restart)
> memqcache_cache_block_size = 1048576
> # Cache block size in bytes. Mandatory
> if memqcache_method = 'shmem'.
> # Defaults to 1MB.
> # (change requires restart)
> memqcache_oiddir = '/var/log/pgpool/oiddir'
> # Temporary work directory to record
> table oids
> # (change requires restart)
> 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
> ---------------------
> postgresql.conf
> -----------------------
> # -----------------------------
> # PostgreSQL configuration file
> # -----------------------------
> #
> # This file consists of lines of the form:
> #
> # name = value
> #
> # (The "=" is optional.) 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 PostgreSQL documentation.
> #
> # The commented-out settings shown in this file represent the default
> values.
> # Re-commenting a setting is NOT sufficient to revert it to the default
> value;
> # you need to reload the server.
> #
> # 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 "pg_ctl reload". Some
> # parameters, which are marked below, require a server shutdown and
> restart to
> # take effect.
> #
> # Any parameter can also be given as a command-line option to the server,
> e.g.,
> # "postgres -c log_connections=on". Some parameters can be changed at run
> time
> # with the "SET" SQL command.
> #
> # Memory units: kB = kilobytes Time units: ms = milliseconds
> # MB = megabytes s = seconds
> # GB = gigabytes min = minutes
> # h = hours
> # d = days
>
>
>
> #------------------------------------------------------------------------------
> # FILE LOCATIONS
>
> #------------------------------------------------------------------------------
>
> # The default values of these variables are driven from the -D command-line
> # option or PGDATA environment variable, represented here as ConfigDir.
>
> data_directory = '/var/lib/postgresql/9.3/main' # use data in
> another directory
> # (change requires restart)
> hba_file = '/etc/postgresql/9.3/main/pg_hba.conf' # host-based
> authentication file
> # (change requires restart)
> ident_file = '/etc/postgresql/9.3/main/pg_ident.conf' # ident
> configuration file
> # (change requires restart)
>
> # If external_pid_file is not explicitly set, no extra PID file is written.
> external_pid_file = '/var/run/postgresql/9.3-main.pid' # write
> an extra PID file
> # (change requires restart)
>
>
>
> #------------------------------------------------------------------------------
> # CONNECTIONS AND AUTHENTICATION
>
> #------------------------------------------------------------------------------
>
> # - Connection Settings -
>
> listen_addresses = '*' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost'; use '*' for all
> # (change requires restart)
> port = 5432 # (change requires restart)
> max_connections = 100 # (change requires restart)
> # Note: Increasing max_connections costs ~400 bytes of shared memory per
> # connection slot, plus lock space (see max_locks_per_transaction).
> #superuser_reserved_connections = 3 # (change requires restart)
> unix_socket_directories = '/var/run/postgresql' # comma-separated list
> of directories
> # (change requires restart)
> #unix_socket_group = '' # (change requires restart)
> #unix_socket_permissions = 0777 # begin with 0 to use octal notation
> # (change requires restart)
> #bonjour = off # advertise server via Bonjour
> # (change requires restart)
> #bonjour_name = '' # defaults to the computer name
> # (change requires restart)
>
> # - Security and Authentication -
>
> #authentication_timeout = 1min # 1s-600s
> ssl = true # (change requires restart)
> #ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
> # (change requires restart)
> #ssl_renegotiation_limit = 512MB # amount of data between renegotiations
> ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change
> requires restart)
> ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' # (change
> requires restart)
> #ssl_ca_file = '' # (change requires restart)
> #ssl_crl_file = '' # (change requires restart)
> #password_encryption = on
> #db_user_namespace = off
>
> # Kerberos and GSSAPI
> #krb_server_keyfile = ''
> #krb_srvname = 'postgres' # (Kerberos only)
> #krb_caseins_users = off
>
> # - TCP Keepalives -
> # see "man 7 tcp" for details
>
> #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
> # 0 selects the system default
> #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
> # 0 selects the system default
> #tcp_keepalives_count = 0 # TCP_KEEPCNT;
> # 0 selects the system default
>
>
>
> #------------------------------------------------------------------------------
> # RESOURCE USAGE (except WAL)
>
> #------------------------------------------------------------------------------
>
> # - Memory -
>
> shared_buffers = 1920MB # min 128kB pgtune wizard 2014-06-30
> (128 mb)
> # (change requires restart)
> #temp_buffers = 8MB # min 800kB
> #max_prepared_transactions = 0 # zero disables the feature
> # (change requires restart)
> # Note: Increasing max_prepared_transactions costs ~600 bytes of shared
> memory
> # per transaction slot, plus lock space (see max_locks_per_transaction).
> # It is not advisable to set max_prepared_transactions nonzero unless you
> # actively intend to use prepared transactions.
> work_mem = 48MB # min 64kB pgtune wizard 2014-06-30 (1MB)
> maintenance_work_mem = 480MB # min 1MB pgtune wizard 2014-06-30 (16)
> #max_stack_depth = 2MB # min 100kB
>
> # - Disk -
>
> #temp_file_limit = -1 # limits per-session temp file space
> # in kB, or -1 for no limit
>
> # - Kernel Resource Usage -
>
> #max_files_per_process = 1000 # min 25
> # (change requires restart)
> #shared_preload_libraries = '' # (change requires restart)
>
> # - Cost-Based Vacuum Delay -
>
> #vacuum_cost_delay = 0 # 0-100 milliseconds
> #vacuum_cost_page_hit = 1 # 0-10000 credits
> #vacuum_cost_page_miss = 10 # 0-10000 credits
> #vacuum_cost_page_dirty = 20 # 0-10000 credits
> #vacuum_cost_limit = 200 # 1-10000 credits
>
> # - Background Writer -
>
> #bgwriter_delay = 200ms # 10-10000ms between rounds
> #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
> #bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers
> scanned/round
>
> # - Asynchronous Behavior -
>
> #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching
>
>
>
> #------------------------------------------------------------------------------
> # WRITE AHEAD LOG
>
> #------------------------------------------------------------------------------
>
> # - Settings -
>
> wal_level = hot_standby # minimal, archive, or hot_standby
> # (change requires restart)
> #fsync = on # turns forced synchronization on or off
> #synchronous_commit = on # synchronization level;
> # off, local, remote_write, or on
> #wal_sync_method = fsync # the default is the first option
> # supported by the operating system:
> # open_datasync
> # fdatasync (default on Linux)
> # fsync
> # fsync_writethrough
> # open_sync
> #full_page_writes = on # recover from partial page writes
> wal_buffers = 8MB # min 32kB, -1 sets based on shared_buffers
> pgtune wizard 2014-06-30 (-1)
> # (change requires restart)
> #wal_writer_delay = 200ms # 1-10000 milliseconds
>
> #commit_delay = 0 # range 0-100000, in microseconds
> #commit_siblings = 5 # range 1-1000
>
> # - Checkpoints -
>
> checkpoint_segments = 16 # in logfile segments, min 1, 16MB each
> pgtunewizard 2014-06-30 (3)
> #checkpoint_timeout = 5min # range 30s-1h
> checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 -
> 1.0 pgtune wizard 2014-06-30 (0.5)
> #checkpoint_warning = 30s # 0 disables
>
> # - Archiving -
>
> #archive_mode = off # allows archiving to be done
> # (change requires restart)i
> #archive_command = 'scp /var/lib/postgresql/9.3/main/%p 10.100.10.171:/tmp/wal/%f'
> # command to use to archive a logfile segment
> # placeholders: %p = path of file to archive
> # %f = file name only
> # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p
> /mnt/server/archivedir/%f'
> #archive_timeout = 0 # force a logfile segment switch after this
> # number of seconds; 0 disables
>
>
>
> #------------------------------------------------------------------------------
> # REPLICATION
>
> #------------------------------------------------------------------------------
>
> # - Sending Server(s) -
>
> # Set these on the master and on any standby that will send replication
> data.
>
> max_wal_senders = 5 # max number of walsender processes (0)
> # (change requires restart)
> wal_keep_segments = 32 # in logfile segments, 16MB each; 0 disables
> #wal_sender_timeout = 60s # in milliseconds; 0 disables
>
> # - Master Server -
>
> # These settings are ignored on a standby server.
>
> #synchronous_standby_names = '' # standby servers that provide sync rep
> # comma-separated list of application_name
> # from standby(s); '*' = all
> #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is
> delayed
>
> # - Standby Servers -
>
> # These settings are ignored on a master server.
>
> hot_standby = off # "on" allows queries during recovery 2014-07-01
> # (change requires restart)
> #max_standby_archive_delay = 30s # max delay before canceling queries
> # when reading WAL from archive;
> # -1 allows indefinite delay
> #max_standby_streaming_delay = 30s # max delay before canceling queries
> # when reading streaming WAL;
> # -1 allows indefinite delay
> #wal_receiver_status_interval = 10s # send replies at least this often
> # 0 disables
> #hot_standby_feedback = off # send info from standby to prevent
> # query conflicts
> #wal_receiver_timeout = 60s # time that receiver waits for
> # communication from master
> # in milliseconds; 0 disables
>
>
>
> #------------------------------------------------------------------------------
> # QUERY TUNING
>
> #------------------------------------------------------------------------------
>
> # - Planner Method Configuration -
>
> #enable_bitmapscan = on
> #enable_hashagg = on
> #enable_hashjoin = on
> #enable_indexscan = on
> #enable_indexonlyscan = on
> #enable_material = on
> #enable_mergejoin = on
> #enable_nestloop = on
> #enable_seqscan = on
> #enable_sort = on
> #enable_tidscan = on
>
> # - Planner Cost Constants -
>
> #seq_page_cost = 1.0 # measured on an arbitrary scale
> #random_page_cost = 4.0 # same scale as above
> #cpu_tuple_cost = 0.01 # same scale as above
> #cpu_index_tuple_cost = 0.005 # same scale as above
> #cpu_operator_cost = 0.0025 # same scale as above
> effective_cache_size = 5632MB # pgtune wizard 2014-06-30
>
> # - Genetic Query Optimizer -
>
> #geqo = on
> #geqo_threshold = 12
> #geqo_effort = 5 # range 1-10
> #geqo_pool_size = 0 # selects default based on effort
> #geqo_generations = 0 # selects default based on effort
> #geqo_selection_bias = 2.0 # range 1.5-2.0
> #geqo_seed = 0.0 # range 0.0-1.0
>
> # - Other Planner Options -
>
> default_statistics_target = 50 # range 1-10000 pgtune wizard
> 2014-06-30 (100)
> constraint_exclusion = on # on, off, or partition pgtune wizard
> 2014-06-30 (partition)
> #cursor_tuple_fraction = 0.1 # range 0.0-1.0
> #from_collapse_limit = 8
> #join_collapse_limit = 8 # 1 disables collapsing of explicit
> # JOIN clauses
>
>
>
> #------------------------------------------------------------------------------
> # ERROR REPORTING AND LOGGING
>
> #------------------------------------------------------------------------------
>
> # - Where to Log -
>
> #log_destination = 'stderr' # Valid values are combinations of
> # stderr, csvlog, syslog, and eventlog,
> # depending on platform. csvlog
> # requires logging_collector to be on.
>
> # This is used when logging to stderr:
> #logging_collector = off # Enable capturing of stderr and csvlog
> # into log files. Required to be on for
> # csvlogs.
> # (change requires restart)
>
> # These are only used if logging_collector is on:
> #log_directory = 'pg_log' # directory where log files are written,
> # can be absolute or relative to PGDATA
> #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name
> pattern,
> # can include strftime() escapes
> #log_file_mode = 0600 # creation mode for log files,
> # begin with 0 to use octal notation
> #log_truncate_on_rotation = off # If on, an existing log file with
> the
> # same name as the new log file will be
> # truncated rather than appended to.
> # But such truncation only occurs on
> # time-driven rotation, not on restarts
> # or size-driven rotation. Default is
> # off, meaning append to existing files
> # in all cases.
> #log_rotation_age = 1d # Automatic rotation of logfiles will
> # happen after that time. 0 disables.
> #log_rotation_size = 10MB # Automatic rotation of logfiles will
> # happen after that much log output.
> # 0 disables.
>
> # These are relevant when logging to syslog:
> #syslog_facility = 'LOCAL0'
> #syslog_ident = 'postgres'
>
> # This is only relevant when logging to eventlog (win32):
> #event_source = 'PostgreSQL'
>
> # - When to Log -
>
> #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
>
> #log_min_error_statement = error # values in order of decreasing detail:
> # debug5
> # debug4
> # debug3
> # debug2
> # debug1
> # info
> # notice
> # warning
> # error
> # log
> # fatal
> # panic (effectively off)
>
> #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
> # and their durations, > 0 logs only
> # statements running at least this number
> # of milliseconds
>
>
> # - What to Log -
>
> #debug_print_parse = off
> #debug_print_rewritten = off
> #debug_print_plan = off
> #debug_pretty_print = on
> #log_checkpoints = off
> #log_connections = off
> #log_disconnections = off
> #log_duration = off
> #log_error_verbosity = default # terse, default, or verbose messages
> #log_hostname = off
> log_line_prefix = '%t ' # special values:
> # %a = application name
> # %u = user name
> # %d = database name
> # %r = remote host and port
> # %h = remote host
> # %p = process ID
> # %t = timestamp without milliseconds
> # %m = timestamp with milliseconds
> # %i = command tag
> # %e = SQL state
> # %c = session ID
> # %l = session line number
> # %s = session start timestamp
> # %v = virtual transaction ID
> # %x = transaction ID (0 if none)
> # %q = stop here in non-session
> # processes
> # %% = '%'
> # e.g. '<%u%%%d> '
> #log_lock_waits = off # log lock waits >= deadlock_timeout
> #log_statement = 'none' # none, ddl, mod, all
> #log_temp_files = -1 # log temporary files equal or larger
> # than the specified size in kilobytes;
> # -1 disables, 0 logs all temp files
> log_timezone = 'localtime'
>
>
>
> #------------------------------------------------------------------------------
> # RUNTIME STATISTICS
>
> #------------------------------------------------------------------------------
>
> # - Query/Index Statistics Collector -
>
> #track_activities = on
> #track_counts = on
> #track_io_timing = off
> #track_functions = none # none, pl, all
> #track_activity_query_size = 1024 # (change requires restart)
> #update_process_title = on
> #stats_temp_directory = 'pg_stat_tmp'
>
>
> # - Statistics Monitoring -
>
> #log_parser_stats = off
> #log_planner_stats = off
> #log_executor_stats = off
> #log_statement_stats = off
>
>
>
> #------------------------------------------------------------------------------
> # AUTOVACUUM PARAMETERS
>
> #------------------------------------------------------------------------------
>
> #autovacuum = on # Enable autovacuum subprocess? 'on'
> # requires track_counts to also be on.
> #log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
> # their durations, > 0 logs only
> # actions running at least this number
> # of milliseconds.
> #autovacuum_max_workers = 3 # max number of autovacuum subprocesses
> # (change requires restart)
> #autovacuum_naptime = 1min # time between autovacuum runs
> #autovacuum_vacuum_threshold = 50 # min number of row updates before
> # vacuum
> #autovacuum_analyze_threshold = 50 # min number of row updates before
> # analyze
> #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before
> vacuum
> #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before
> analyze
> #autovacuum_freeze_max_age = 200000000 # maximum XID age before forced
> vacuum
> # (change requires restart)
> #autovacuum_multixact_freeze_max_age = 400000000 # maximum Multixact age
> # before forced vacuum
> # (change requires restart)
> #autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
> # autovacuum, in milliseconds;
> # -1 means use vacuum_cost_delay
> #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
> # autovacuum, -1 means use
> # vacuum_cost_limit
>
>
>
> #------------------------------------------------------------------------------
> # CLIENT CONNECTION DEFAULTS
>
> #------------------------------------------------------------------------------
>
> # - Statement Behavior -
>
> #search_path = '"$user",public' # schema names
> #default_tablespace = '' # a tablespace name, '' uses the default
> #temp_tablespaces = '' # a list of tablespace names, '' uses
> # only default tablespace
> #check_function_bodies = on
> #default_transaction_isolation = 'read committed'
> #default_transaction_read_only = off
> #default_transaction_deferrable = off
> #session_replication_role = 'origin'
> #statement_timeout = 0 # in milliseconds, 0 is disabled
> #lock_timeout = 0 # in milliseconds, 0 is disabled
> #vacuum_freeze_min_age = 50000000
> #vacuum_freeze_table_age = 150000000
> #vacuum_multixact_freeze_min_age = 5000000
> #vacuum_multixact_freeze_table_age = 150000000
> #bytea_output = 'hex' # hex, escape
> #xmlbinary = 'base64'
> #xmloption = 'content'
>
> # - Locale and Formatting -
>
> datestyle = 'iso, dmy'
> #intervalstyle = 'postgres'
> timezone = 'localtime'
> #timezone_abbreviations = 'Default' # Select the set of available time
> zone
> # abbreviations. Currently, there are
> # Default
> # Australia
> # India
> # You can create your own file in
> # share/timezonesets/.
> #extra_float_digits = 0 # min -15, max 3
> #client_encoding = sql_ascii # actually, defaults to database
> # encoding
>
> # These settings are initialized by initdb, but they can be changed.
> lc_messages = 'es_VE.UTF-8' # locale for system error message
> # strings
> lc_monetary = 'es_VE.UTF-8' # locale for monetary formatting
> lc_numeric = 'es_VE.UTF-8' # locale for number formatting
> lc_time = 'es_VE.UTF-8' # locale for time formatting
>
> # default configuration for text search
> default_text_search_config = 'pg_catalog.spanish'
>
> # - Other Defaults -
>
> #dynamic_library_path = '$libdir'
> #local_preload_libraries = ''
>
>
>
> #------------------------------------------------------------------------------
> # LOCK MANAGEMENT
>
> #------------------------------------------------------------------------------
>
> #deadlock_timeout = 1s
> #max_locks_per_transaction = 64 # min 10
> # (change requires restart)
> # Note: Each lock table slot uses ~270 bytes of shared memory, and there
> are
> # max_locks_per_transaction * (max_connections + max_prepared_transactions)
> # lock table slots.
> #max_pred_locks_per_transaction = 64 # min 10
> # (change requires restart)
>
>
>
> #------------------------------------------------------------------------------
> # VERSION/PLATFORM COMPATIBILITY
>
> #------------------------------------------------------------------------------
>
> # - Previous PostgreSQL Versions -
>
> #array_nulls = on
> #backslash_quote = safe_encoding # on, off, or safe_encoding
> #default_with_oids = off
> #escape_string_warning = on
> #lo_compat_privileges = off
> #quote_all_identifiers = off
> #sql_inheritance = on
> #standard_conforming_strings = on
> #synchronize_seqscans = on
>
> # - Other Platforms and Clients -
>
> #transform_null_equals = off
>
>
>
> #------------------------------------------------------------------------------
> # ERROR HANDLING
>
> #------------------------------------------------------------------------------
>
> #exit_on_error = off # terminate session on any error?
> #restart_after_crash = on # reinitialize after backend crash?
>
>
>
> #------------------------------------------------------------------------------
> # CONFIG FILE INCLUDES
>
> #------------------------------------------------------------------------------
>
> # These options allow settings to be loaded from files other than the
> # default postgresql.conf.
>
> #include_dir = 'conf.d' # include files ending in '.conf' from
> # directory 'conf.d'
> #include_if_exists = 'exists.conf' # include file only if it exists
> #include = 'special.conf' # include file
>
>
>
> #------------------------------------------------------------------------------
> # CUSTOMIZED OPTIONS
>
> #------------------------------------------------------------------------------
>
> # Add settings for extensions here
>
>
> --------
> extract from pgpool.log
> --------
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: listen_addresses
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '*' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9999 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: socket_dir
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/tmp' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: pcp_port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9898 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: pcp_socket_dir
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/tmp' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_hostname0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '10.100.10.171' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_port0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 5432 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: port slot number 0
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_weight0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 1 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: weight slot number 0
> weight: 1.000000
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_data_directory0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value:
> '/var/lib/postgresql/9.3/main/' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_flag0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'ALLOW_TO_FAILOVER' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token:
> ALLOW_TO_FAILOVER
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: allow_to_failover on
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: slot number 0 flag: 0000
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_hostname1
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '10.100.10.173' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_port1
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 5432 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: port slot number 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_weight1
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 1 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: weight slot number 1
> weight: 1.000000
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_data_directory1
> 2014-07-07 15:45:26 DEBUG: pid 7565: value:
> '/var/lib/postgresql/9.3/main/' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: backend_flag1
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'ALLOW_TO_FAILOVER' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token:
> ALLOW_TO_FAILOVER
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: allow_to_failover on
> 2014-07-07 15:45:26 DEBUG: pid 7565: pool_config: slot number 1 flag: 0000
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: enable_pool_hba
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: pool_passwd
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: authentication_timeout
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 60 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: ssl
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: num_init_children
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 32 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: max_pool
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 4 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: child_life_time
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 300 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: child_max_connections
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: connection_life_time
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: client_idle_limit
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_destination
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'stderr' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: print_timestamp
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_connections
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_hostname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_statement
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_per_node_statement
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: log_standby_delay
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'none' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: syslog_facility
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'LOCAL0' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: syslog_ident
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'pgpool' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: debug_level
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: pid_file_name
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/var/run/pgpool/pgpool.pid'
> kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: logdir
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/tmp' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: connection_cache
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: reset_query_list
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'ABORT; DISCARD ALL' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token: ABORT
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token:
> DISCARD ALL
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: replication_mode
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: replicate_select
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: replicate_select: 0
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: insert_lock
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: lobj_lock_table
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: replication_stop_on_mismatch
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: replication_stop_on_mismatch: 0
> 2014-07-07 15:45:26 DEBUG: pid 7565: key:
> failover_if_affected_tuples_mismatch
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: failover_if_affected_tuples_mismatch:
> 0
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: load_balance_mode
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: ignore_leading_white_space
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: white_function_list
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: black_function_list
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'nextval,setval' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token: nextval
> 2014-07-07 15:45:26 DEBUG: pid 7565: extract_string_tokens: token: setval
> 2014-07-07 15:45:26 DEBUG: pid 7565: add_to_patterns: regex pattern:
> ^nextval$
> 2014-07-07 15:45:26 DEBUG: pid 7565: add_to_patterns: regex pattern:
> ^setval$
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: master_slave_mode
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: master_slave_sub_mode
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'stream' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: sr_check_period
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: sr_check_user
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'postgres' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: sr_check_password
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'postgres' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: delay_threshold
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: follow_master_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: parallel_mode
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: pgpool2_hostname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_hostname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'localhost' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 5432 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_dbname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'pgpool' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_schema
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'pgpool_catalog' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_user
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'pgpool' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: system_db_password
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_period
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 5 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_timeout
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_user
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'postgres' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_password
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_max_retries
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: health_check_retry_delay
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 1 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: failover_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/usr/local/etc/failover.sh %d
> %P %H %R' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: failback_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: fail_over_on_backend_error
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: search_primary_node_timeout
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 10 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: recovery_user
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'postgres' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: recovery_password
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'postgres' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: recovery_1st_stage_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'recovery_1st_stage' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: recovery_2nd_stage_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: recovery_timeout
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 90 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: client_idle_limit_in_recovery
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: use_watchdog
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: trusted_servers
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: ping_path
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/bin' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_hostname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '10.100.10.171' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9000 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_authkey
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: delegate_IP
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '192.168.1.101' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: ifconfig_path
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/home/www-data/sbin' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: if_up_cmd
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'ifconfig eth0:0 inet $_IP_$
> netmask 255.255.255.0' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: if_down_cmd
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'ifconfig eth0:0 down' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: arping_path
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/home/www-data/sbin' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: arping_cmd
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'arping -U $_IP_$ -w 1' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: clear_memqcache_on_escalation
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_escalation_command
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_lifecheck_method
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'heartbeat' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_interval
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 3 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_heartbeat_port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9694 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_heartbeat_keepalive
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 2 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_heartbeat_deadtime
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 30 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: heartbeat_destination0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '10.100.10.173' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: heartbeat_destination_port0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9694 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: heartbeat_device0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_life_point
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 3 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_lifecheck_query
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'SELECT 1' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_lifecheck_dbname
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'template1' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_lifecheck_user
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'nobody' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: wd_lifecheck_password
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: other_pgpool_hostname0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '10.100.10.173' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: other_pgpool_port0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9999 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: other_wd_port0
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 9000 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: relcache_expire
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: relcache_size
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 256 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: check_temp_table
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memory_cache_enabled
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: off kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_method
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'shmem' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_memcached_host
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 'localhost' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_memcached_port
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 11211 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_total_size
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 67108864 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_max_num_cache
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 1000000 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_expire
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 0 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_auto_cache_invalidation
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: on kind: 1
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_maxcache
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 409600 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_cache_block_size
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: 1048576 kind: 2
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: memqcache_oiddir
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '/var/log/pgpool/oiddir' kind:
> 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: white_memqcache_table_list
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: key: black_memqcache_table_list
> 2014-07-07 15:45:26 DEBUG: pid 7565: value: '' kind: 4
> 2014-07-07 15:45:26 DEBUG: pid 7565: num_backends: 2 total_weight: 2.000000
> 2014-07-07 15:45:26 DEBUG: pid 7565: backend 0 weight: 1073741823.500000
> 2014-07-07 15:45:26 DEBUG: pid 7565: backend 0 flag: 0000
> 2014-07-07 15:45:26 DEBUG: pid 7565: backend 1 weight: 1073741823.500000
> 2014-07-07 15:45:26 DEBUG: pid 7565: backend 1 flag: 0000
> 2014-07-07 15:45:26 LOG: pid 7565: wd_chk_setuid all commands have
> setuid bit
> 2014-07-07 15:45:26 LOG: pid 7565: watchdog might call network commands
> which using setuid bit.
> 2014-07-07 15:45:26 LOG: pid 7565: wd_create_send_socket: connect()
> reports failure (Connection refused). You can safely ignore this while
> starting up.
> 2014-07-07 15:45:26 LOG: pid 7565: send_packet_4_nodes: packet for
> 10.100.10.173:9000 is canceled
> 2014-07-07 15:45:38 DEBUG: pid 7565: exec_ping: failed to ping
> 192.168.1.101: exit code 1
> 2014-07-07 15:45:38 LOG: pid 7565: wd_escalation: escalating to master
> pgpool
> 2014-07-07 15:45:38 DEBUG: pid 7565: exec_ifconfig: 'ifconfig eth0:0 inet
> $_IP_$ netmask 255.255.255.0' succeeded
> arping: invalid option -- 'U'
> 2014-07-07 15:45:38 DEBUG: pid 7565: exec_ifconfig: 'arping -U $_IP_$ -w
> 1' failed. exit status: 1
> 2014-07-07 15:45:38 ERROR: pid 7565: wd_IP_up: ifconfig up failed
> 2014-07-07 15:45:38 DEBUG: pid 7565: wd_declare: send the packet to
> declare the new master
> 2014-07-07 15:45:38 LOG: pid 7565: wd_escalation: escalated to master
> pgpool with some errors
> 2014-07-07 15:45:38 LOG: pid 7565: wd_init: start watchdog
> 2014-07-07 15:45:38 DEBUG: pid 7610: I am 7610
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140709/313edb69/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 341.gif
Type: image/gif
Size: 750 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140709/313edb69/attachment-0001.gif>
More information about the pgpool-general
mailing list