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