<div dir="ltr">Same error!!!!<div><br></div><div><div>-rw-r--r--. 1 apache postgres 45 abr 11 17:09 pool_passwd</div></div><div><br></div><div><br></div><div><br></div><div><div>-bash-4.2$ psql -h localhost -U postgres -p 9999</div><div>psql: ERROR: unable to read message length</div><div>DETALLE: message length (12) in slot 1 does not match with slot 0(8)</div></div><div><br></div><div>pool_passwd</div><div><br></div><div><div>postgres:md59798b5eb1000b9fad41c78e5a3dccxxx</div></div><div><br></div><div><br></div><div><div>select * from pg_shadow where usename='postgres';</div><div><br></div><div>md59798b5eb1000b9fad41c78e5a3dccxxx</div></div><div><br></div><div>the pool_passwd permision is ok?</div><div>I do not know what else to do!!! </div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-08 20:56 GMT-03:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">> Yes Tatsuo we have encrypted the postgres user in both servers<br>
><br>
> SELECT * from pg_shadow a WHERE a.usename='postgres';<br>
><br>
> postgres 10 t t t t md59798b5eb1000b9fad41c78e5a3dccxxx<br>
><br>
> Is diferent a pcp.conf<br>
><br>
> # USERID:MD5PASSWD<br>
> postgres:5c0435eee0f211f150e980e459151xxx<br>
<br>
</span>I assume it's pool_passwd. It seems the pool_passwd was correctly<br>
setup. Please see the doc:<br>
<br>
<a href="http://www.pgpool.net/docs/latest/pgpool-en.html#md5" rel="noreferrer" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#md5</a><br>
<div><div class="h5"><br>
> thanks again for your time!!<br>
><br>
><br>
><br>
> 2016-04-07 23:57 GMT-03:00 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>:<br>
><br>
>> pg_hba.conf looks good. So the user in question has encrypted<br>
>> password on the both PostgreSQL server? You can check it by looking at<br>
>> pg_shadow (needs PostgreSQL super user privilege). The "password"<br>
>> column should look something like "md5.....".<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Thanks a lots for your time!!!!<br>
>> ><br>
>> > Master pgpool.conf and pg_hba.conf<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<br>
>> > line.<br>
>> > # The complete list of parameter names and allowed values can be found in<br>
>> > the<br>
>> > # pgPool-II documentation.<br>
>> > #<br>
>> > # This file is read on server startup and when the server receives a<br>
>> SIGHUP<br>
>> > # signal. If you edit the file on a running system, you have to SIGHUP<br>
>> 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<br>
>> restart<br>
>> > to<br>
>> > # take effect.<br>
>> > #<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # CONNECTIONS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - pgpool Connection Settings -<br>
>> ><br>
>> > listen_addresses = '*'<br>
>> > # Host name or IP address to listen<br>
>> on:<br>
>> > # '*' for all, '' for no TCP/IP<br>
>> > 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_listen_addresses = '*'<br>
>> > # Host name or IP address for pcp<br>
>> > process to listen on:<br>
>> > # '*' for all, '' for no TCP/IP<br>
>> > connections<br>
>> > # (change requires restart)<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>
>> > listen_backlog_multiplier = 2<br>
>> > # Set the backlog parameter of<br>
>> listen(2)<br>
>> > to<br>
>> > # num_init_children * listen_backlog_multiplier.<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Backend Connection Settings -<br>
>> ><br>
>> > # Host name or IP address to connect<br>
>> to<br>
>> > for backend 0<br>
>> > # Port number for backend 0<br>
>> > # Weight for backend 0 (only in load<br>
>> > balancing mode)<br>
>> > # Data directory for backend 0<br>
>> > # Controls various backend behavior<br>
>> > # ALLOW_TO_FAILOVER or<br>
>> > DISALLOW_TO_FAILOVER<br>
>> ><br>
>> > # - Authentication -<br>
>> ><br>
>> > enable_pool_hba = on<br>
>> > # Use pool_hba.conf for client<br>
>> > authentication<br>
>> > pool_passwd = 'pool_passwd'<br>
>> > # File name of pool_passwd for md5<br>
>> > authentication.<br>
>> > # "" disables pool_passwd.<br>
>> > # (change requires restart)<br>
>> > authentication_timeout = 60<br>
>> > # Delay in seconds to complete client<br>
>> > 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<br>
>> 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<br>
>> > certificate(s)<br>
>> > # (change requires restart)<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # POOLS<br>
>> ><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<br>
>> > many seconds<br>
>> > child_max_connections = 0<br>
>> > # Pool exits after receiving that many<br>
>> > connections<br>
>> > # 0 means no exit<br>
>> > connection_life_time = 0<br>
>> > # Connection to backend closes after<br>
>> > being idle for this many seconds<br>
>> > # 0 means no close<br>
>> > client_idle_limit = 0<br>
>> > # Client is disconnected after being<br>
>> > idle for that many seconds<br>
>> > # (even inside an explicit<br>
>> transactions!)<br>
>> > # 0 means no disconnection<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # LOGS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - Where to log -<br>
>> ><br>
>> > log_destination = 'syslog'<br>
>> > # Where to log<br>
>> > # Valid values are combinations of<br>
>> > stderr,<br>
>> > # and syslog. Default to stderr.<br>
>> ><br>
>> > # - What to log -<br>
>> ><br>
>> > log_line_prefix = '%t: pid %p: # printf-style string to output at<br>
>> > beginning of each log line.'<br>
>> ><br>
>> > log_connections = off<br>
>> > # Log connections<br>
>> > log_hostname = on<br>
>> > # Hostname will be shown in ps status<br>
>> > # and in logs if connections are<br>
>> logged<br>
>> > log_statement = on<br>
>> > # Log all statements<br>
>> > log_per_node_statement = on<br>
>> > # Log all statements<br>
>> > # with node and backend informations<br>
>> > log_standby_delay = 'if_over_threshold'<br>
>> > # Log standby delay<br>
>> > # Valid values are combinations of<br>
>> > always,<br>
>> > # if_over_threshold, none<br>
>> ><br>
>> > # - Syslog specific -<br>
>> ><br>
>> > syslog_facility = 'LOCAL0'<br>
>> > # Syslog local facility. Default to<br>
>> > LOCAL0<br>
>> > syslog_ident = 'pgpool'<br>
>> > # Syslog program identification string<br>
>> > # Default to 'pgpool'<br>
>> ><br>
>> > # - Debug -<br>
>> ><br>
>> > debug_level = 5<br>
>> > # Debug message verbosity level<br>
>> > # 0 means no message, 1 or more mean<br>
>> > verbose<br>
>> ><br>
>> > log_error_verbosity = 'DEFAULT'<br>
>> ><br>
>> > #client_min_messages = notice # values in order of decreasing<br>
>> > 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<br>
>> > 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>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # FILE LOCATIONS<br>
>> ><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>
>> #------------------------------------------------------------------------------<br>
>> > # CONNECTION POOLING<br>
>> ><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<br>
>> before<br>
>> > #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # REPLICATION MODE<br>
>> ><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 mode<br>
>> > # replicate_select is higher priority<br>
>> > than<br>
>> > # load_balance_mode.<br>
>> ><br>
>> > insert_lock = off<br>
>> > # Automatically locks a dummy row or a<br>
>> > table<br>
>> > # with INSERT statements to keep<br>
>> SERIAL<br>
>> > data<br>
>> > # consistency<br>
>> > # Without SERIAL, no lock will be<br>
>> issued<br>
>> > lobj_lock_table = ''<br>
>> > # When rewriting lo_creat command in<br>
>> > # replication mode, specify table<br>
>> 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<br>
>> node<br>
>> > # which is most likely "minority"<br>
>> > # If off, just force to exit this<br>
>> session<br>
>> ><br>
>> > failover_if_affected_tuples_mismatch = off<br>
>> > # On disagreement with the number of<br>
>> > affected<br>
>> > # tuples in UPDATE/DELETE queries,<br>
>> then<br>
>> > # degenerate the node which is most<br>
>> > likely<br>
>> > # "minority".<br>
>> > # If off, just abort the transaction<br>
>> to<br>
>> > # keep the consistency<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # LOAD BALANCING MODE<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > load_balance_mode = on<br>
>> > # Activate load balancing mode<br>
>> > # (change requires restart)<br>
>> > ignore_leading_white_space = on<br>
>> > # Ignore leading white spaces of each<br>
>> > query<br>
>> > white_function_list = ''<br>
>> > # Comma separated list of function<br>
>> names<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > black_function_list = 'currval,lastval,nextval,setval'<br>
>> > # Comma separated list of function<br>
>> names<br>
>> > # that write to database<br>
>> > # Regexp are accepted<br>
>> ><br>
>> > database_redirect_preference_list = ''<br>
>> > # comma separated list of pairs of database and node id.<br>
>> > # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'<br>
>> > # valid for streaming replicaton mode only.<br>
>> ><br>
>> > app_name_redirect_preference_list = ''<br>
>> > # comma separated list of pairs of app name and node id.<br>
>> > # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'<br>
>> > # valid for streaming replicaton mode only.<br>
>> > allow_sql_comments = off<br>
>> > # if on, ignore SQL comments when judging if load balance or<br>
>> > # query cache is possible.<br>
>> > # If off, SQL comments effectively prevent the judgment<br>
>> > # (pre 3.4 behavior).<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # MASTER/SLAVE MODE<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > master_slave_mode = on<br>
>> > # Activate master/slave mode<br>
>> > # (change requires restart)<br>
>> > master_slave_sub_mode = 'stream'<br>
>> > # Master/slave sub mode<br>
>> > # Valid values are combinations slony<br>
>> 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 neccessary even if you<br>
>> disable<br>
>> > streaming<br>
>> > # replication delay check by<br>
>> > sr_check_period = 0<br>
>> > sr_check_password = 'xxx'<br>
>> > # Password for streaming replication<br>
>> > check user<br>
>> > delay_threshold = 0<br>
>> > # Threshold before not dispatching<br>
>> query<br>
>> > 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<br>
>> > 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<br>
>> 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>
>> > # HEALTH CHECK<br>
>> ><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<br>
>> > health_check_password = 'xxx'<br>
>> > # Password for health check user<br>
>> > health_check_max_retries = 0<br>
>> > # Maximum number of times to retry a<br>
>> > failed health check before giving up.<br>
>> > health_check_retry_delay = 1<br>
>> > # Amount of time to wait (in seconds)<br>
>> > between retries.<br>
>> > connect_timeout = 10000<br>
>> > # Timeout value in milliseconds before<br>
>> > giving up to connect to backend.<br>
>> > # Default is 10000 ms (10 second). Flaky network user may want to<br>
>> increase<br>
>> > # the value. 0 means no timeout.<br>
>> > # Note that this value is not only used for health check,<br>
>> > # but also for ordinary conection to backend.<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # FAILOVER AND FAILBACK<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > failover_command = '/usr/local/etc/failover.sh %d %H<br>
>> > /var/log/pgpool/trigger/trigger_file0'<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<br>
>> 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<br>
>> 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<br>
>> > 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>
>> #------------------------------------------------------------------------------<br>
>> > # ONLINE RECOVERY<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > recovery_user = 'postgres'<br>
>> > # Online recovery user<br>
>> > recovery_password = 'xxx'<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<br>
>> start<br>
>> > up<br>
>> > # 0 means no wait<br>
>> > client_idle_limit_in_recovery = 0<br>
>> > # Client is disconnected after being<br>
>> idle<br>
>> > # for that many seconds in the second<br>
>> > stage<br>
>> > # of online recovery<br>
>> > # 0 means no disconnection<br>
>> > # -1 means immediate disconnection<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # WATCHDOG<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - Enabling -<br>
>> ><br>
>> > use_watchdog = on<br>
>> > # Activates watchdog<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 = 'SUYSevPrepDB01'<br>
>> > # Host name or IP address of this<br>
>> > 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<br>
>> > communication<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Virtual IP control Setting -<br>
>> ><br>
>> > delegate_IP = '192.168.140.112'<br>
>> > # delegate IP address<br>
>> > # If this is empty, virtual IP never<br>
>> > bring up.<br>
>> > # (change requires restart)<br>
>> > ifconfig_path = '/apachebin'<br>
>> > # ifconfig command path<br>
>> > # (change requires restart)<br>
>> > if_up_cmd = 'ifconfig eth1:0 inet $_IP_$ netmask 255.255.255.0'<br>
>> > # startup delegate IP command<br>
>> > # (change requires restart)<br>
>> > if_down_cmd = 'ifconfig eth1:0 down'<br>
>> > # shutdown delegate IP command<br>
>> > # (change requires restart)<br>
>> ><br>
>> > arping_path = '/apachebin'<br>
>> > # (change requires restart)<br>
>> ><br>
>> > arping_cmd = 'arping -I eth0 -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<br>
>> > memory<br>
>> > # when standby pgpool escalate to<br>
>> > active pgpool<br>
>> > # (= virtual IP holder).<br>
>> > # This should be off if client<br>
>> connects<br>
>> > to pgpool<br>
>> > # not using virtual IP.<br>
>> > # (change requires restart)<br>
>> > wd_escalation_command = ''<br>
>> > # Executes this command at escalation<br>
>> > 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<br>
>> > ('heartbeat' or 'query')<br>
>> > # (change requires restart)<br>
>> > wd_interval = 3<br>
>> > # lifecheck interval (sec) > 0<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # -- heartbeat mode --<br>
>> ><br>
>> > wd_heartbeat_port = 9694<br>
>> > # Port number for receiving heartbeat<br>
>> > signal<br>
>> > # (change requires restart)<br>
>> > wd_heartbeat_keepalive = 2<br>
>> > # Interval time of sending heartbeat<br>
>> > signal (sec)<br>
>> > # (change requires restart)<br>
>> > wd_heartbeat_deadtime = 30<br>
>> > # Deadtime interval for heartbeat<br>
>> > signal (sec)<br>
>> > # (change requires restart)<br>
>> > # Host name or IP address of<br>
>> > destination 0<br>
>> > # for sending heartbeat signal.<br>
>> > # (change requires restart)<br>
>> > # Port number of destination 0 for<br>
>> > sending<br>
>> > # heartbeat signal. Usually this is<br>
>> the<br>
>> > # same as wd_heartbeat_port.<br>
>> > # (change requires restart)<br>
>> > # Name of NIC device (such like<br>
>> 'eth0')<br>
>> > # used for sending/receiving<br>
>> heartbeat<br>
>> > # signal to/from destination 0.<br>
>> > # This works only when this is not<br>
>> 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<br>
>> > watchdog<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_dbname = 'template1'<br>
>> > # Database name connected for<br>
>> lifecheck<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_user = ''<br>
>> > # watchdog user monitoring pgpools in<br>
>> > lifecheck<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_password = ''<br>
>> > # Password for watchdog user in<br>
>> > lifecheck<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Other pgpool Connection Settings -<br>
>> ><br>
>> > # Host name or IP address to connect<br>
>> to<br>
>> > for other pgpool 0<br>
>> > # (change requires restart)<br>
>> > # Port number for othet pgpool 0<br>
>> > # (change requires restart)<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>
>> #------------------------------------------------------------------------------<br>
>> > # OTHERS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > relcache_expire = 0<br>
>> > # Life time of relation cache in<br>
>> seconds.<br>
>> > # 0 means no cache expiration(the<br>
>> > default).<br>
>> > # The relation cache is used for cache<br>
>> > the<br>
>> > # query result against PostgreSQL<br>
>> system<br>
>> > # catalog to obtain various<br>
>> information<br>
>> > # including table structures or if<br>
>> it's a<br>
>> > # temporary table or not. The cache is<br>
>> > # maintained in a pgpool child local<br>
>> > memory<br>
>> > # and being kept as long as it<br>
>> survives.<br>
>> > # If someone modify the table by using<br>
>> > # ALTER TABLE or some such, the<br>
>> relcache<br>
>> > is<br>
>> > # not consistent anymore.<br>
>> > # For this purpose, cache_expiration<br>
>> > # controls the life time of the cache.<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<br>
>> in<br>
>> > SELECT statements.<br>
>> > # This initiates queries against<br>
>> system<br>
>> > catalog of primary/master<br>
>> > # thus increases load of master.<br>
>> > # If you are absolutely sure that your system never uses temporary<br>
>> tables<br>
>> > # and you want to save access to primary/master, you could turn this<br>
>> off.<br>
>> > # Default is on.<br>
>> ><br>
>> > check_unlogged_table = off<br>
>> > # If on, enable unlogged table check<br>
>> in<br>
>> > SELECT statements.<br>
>> > # This initiates queries against<br>
>> system<br>
>> > catalog of primary/master<br>
>> > # thus increases load of master.<br>
>> > # If you are absolutely sure that your<br>
>> > system never uses unlogged tables<br>
>> > # and you want to save access to<br>
>> > primary/master, you could turn this off.<br>
>> > # Default is on.<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # IN MEMORY QUERY MEMORY CACHE<br>
>> ><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<br>
>> to<br>
>> > memcache<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > black_memqcache_table_list = ''<br>
>> > # Comma separated list of table names<br>
>> > not to memcache<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > ssl_key = ''<br>
>> > ssl_cert = ''<br>
>> > ssl_ca_cert = ''<br>
>> > ssl_ca_cert_dir = ''<br>
>> > log_error_verbosity = 'DEFAULT'<br>
>> > client_min_messages = 'debug2'<br>
>> > log_min_messages = 'debug2'<br>
>> > backend_hostname0 = 'SUYSevPrepDB01'<br>
>> > backend_port0 = 5432<br>
>> > backend_weight0 = 1<br>
>> > backend_data_directory0 = '/var/lib/pgsql/9.4/data'<br>
>> > backend_flag0= 'ALLOW_TO_FAILOVER'<br>
>> > backend_hostname1 = 'SUYSevPrepDB02'<br>
>> > backend_port1 = 5432<br>
>> > backend_weight1 = 1<br>
>> > backend_data_directory1 = '/var/lib/pgsql/9.4/data'<br>
>> > backend_flag1= 'ALLOW_TO_FAILOVER'<br>
>> > other_pgpool_hostname0 = 'SUYSevPrepDB02'<br>
>> > other_pgpool_port0 = 9999<br>
>> > other_wd_port0 = 9000<br>
>> > heartbeat_destination0 = 'SUYSevPrepDB02'<br>
>> > heartbeat_destination_port0 = 9694<br>
>> > heartbeat_device0 = ''<br>
>> ><br>
>> > # use another authentication method.<br>
>> ><br>
>> ><br>
>> > # TYPE DATABASE USER ADDRESS METHOD<br>
>> ><br>
>> > # "local" is for Unix domain socket connections only<br>
>> > local all all md5<br>
>> > # IPv4 local connections:<br>
>> > host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> md5<br>
>> > host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>> > # IPv6 local connections:<br>
>> > # Allow replication connections from localhost, by a user with the<br>
>> > # replication privilege.<br>
>> > local replication postgres trust<br>
>> > host replication replication <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> trust<br>
>> > #host replication postgres ::1/128 trust<br>
>> > "9.4/data/pg_hba.conf" 93L, 4422C<br>
>> ><br>
>> ><br>
>> > Slave pgpool.conf and pg_hba.conf<br>
>> ><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<br>
>> > line.<br>
>> > # The complete list of parameter names and allowed values can be found in<br>
>> > the<br>
>> > # pgPool-II documentation.<br>
>> > #<br>
>> > # This file is read on server startup and when the server receives a<br>
>> SIGHUP<br>
>> > # signal. If you edit the file on a running system, you have to SIGHUP<br>
>> 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<br>
>> restart<br>
>> > to<br>
>> > # take effect.<br>
>> > #<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # CONNECTIONS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - pgpool Connection Settings -<br>
>> ><br>
>> > listen_addresses = '*'<br>
>> > # Host name or IP address to listen<br>
>> on:<br>
>> > # '*' for all, '' for no TCP/IP<br>
>> > 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_listen_addresses = '*'<br>
>> > # Host name or IP address for pcp<br>
>> > process to listen on:<br>
>> > # '*' for all, '' for no TCP/IP<br>
>> > connections<br>
>> > # (change requires restart)<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>
>> > listen_backlog_multiplier = 2<br>
>> > # Set the backlog parameter of<br>
>> listen(2)<br>
>> > to<br>
>> > # num_init_children * listen_backlog_multiplier.<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Backend Connection Settings -<br>
>> ><br>
>> > # Host name or IP address to connect<br>
>> to<br>
>> > for backend 0<br>
>> > # Port number for backend 0<br>
>> > # Weight for backend 0 (only in load<br>
>> > balancing mode)<br>
>> > # Data directory for backend 0<br>
>> > # Controls various backend behavior<br>
>> > # ALLOW_TO_FAILOVER or<br>
>> > DISALLOW_TO_FAILOVER<br>
>> ><br>
>> > # - Authentication -<br>
>> ><br>
>> > enable_pool_hba = on<br>
>> > # Use pool_hba.conf for client<br>
>> > authentication<br>
>> > pool_passwd = 'pool_passwd'<br>
>> > # File name of pool_passwd for md5<br>
>> > authentication.<br>
>> > # "" disables pool_passwd.<br>
>> > # (change requires restart)<br>
>> > authentication_timeout = 60<br>
>> > # Delay in seconds to complete client<br>
>> > 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<br>
>> 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<br>
>> > certificate(s)<br>
>> > # (change requires restart)<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # POOLS<br>
>> ><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<br>
>> > many seconds<br>
>> > child_max_connections = 0<br>
>> > # Pool exits after receiving that many<br>
>> > connections<br>
>> > # 0 means no exit<br>
>> > connection_life_time = 0<br>
>> > # Connection to backend closes after<br>
>> > being idle for this many seconds<br>
>> > # 0 means no close<br>
>> > client_idle_limit = 0<br>
>> > # Client is disconnected after being<br>
>> > idle for that many seconds<br>
>> > # (even inside an explicit<br>
>> transactions!)<br>
>> > # 0 means no disconnection<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # LOGS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - Where to log -<br>
>> ><br>
>> > log_destination = 'syslog'<br>
>> > # Where to log<br>
>> > # Valid values are combinations of<br>
>> > stderr,<br>
>> > # and syslog. Default to stderr.<br>
>> ><br>
>> > # - What to log -<br>
>> ><br>
>> > log_line_prefix = '%t: pid %p: # printf-style string to output at<br>
>> > beginning of each log line.'<br>
>> ><br>
>> > log_connections = off<br>
>> > # Log connections<br>
>> > log_hostname = on<br>
>> > # Hostname will be shown in ps status<br>
>> > # and in logs if connections are<br>
>> logged<br>
>> > log_statement = on<br>
>> > # Log all statements<br>
>> > log_per_node_statement = on<br>
>> > # Log all statements<br>
>> > # with node and backend informations<br>
>> > log_standby_delay = 'if_over_threshold'<br>
>> > # Log standby delay<br>
>> > # Valid values are combinations of<br>
>> > always,<br>
>> > # if_over_threshold, none<br>
>> ><br>
>> > # - Syslog specific -<br>
>> ><br>
>> > syslog_facility = 'LOCAL0'<br>
>> > # Syslog local facility. Default to<br>
>> > LOCAL0<br>
>> > syslog_ident = 'pgpool'<br>
>> > # Syslog program identification string<br>
>> > # Default to 'pgpool'<br>
>> ><br>
>> > # - Debug -<br>
>> ><br>
>> > debug_level = 2<br>
>> > # Debug message verbosity level<br>
>> > # 0 means no message, 1 or more mean<br>
>> > verbose<br>
>> ><br>
>> > #log_error_verbosity = default # terse, default, or verbose<br>
>> > messages<br>
>> ><br>
>> > #client_min_messages = notice # values in order of decreasing<br>
>> > 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<br>
>> > 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>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # FILE LOCATIONS<br>
>> ><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>
>> #------------------------------------------------------------------------------<br>
>> > # CONNECTION POOLING<br>
>> ><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<br>
>> before<br>
>> > #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # REPLICATION MODE<br>
>> ><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 mode<br>
>> > # replicate_select is higher priority<br>
>> > than<br>
>> > # load_balance_mode.<br>
>> ><br>
>> > insert_lock = off<br>
>> > # Automatically locks a dummy row or a<br>
>> > table<br>
>> > # with INSERT statements to keep<br>
>> SERIAL<br>
>> > data<br>
>> > # consistency<br>
>> > # Without SERIAL, no lock will be<br>
>> issued<br>
>> > lobj_lock_table = ''<br>
>> > # When rewriting lo_creat command in<br>
>> > # replication mode, specify table<br>
>> 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<br>
>> node<br>
>> > # which is most likely "minority"<br>
>> > # If off, just force to exit this<br>
>> session<br>
>> ><br>
>> > failover_if_affected_tuples_mismatch = off<br>
>> > # On disagreement with the number of<br>
>> > affected<br>
>> > # tuples in UPDATE/DELETE queries,<br>
>> then<br>
>> > # degenerate the node which is most<br>
>> > likely<br>
>> > # "minority".<br>
>> > # If off, just abort the transaction<br>
>> to<br>
>> > # keep the consistency<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # LOAD BALANCING MODE<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > load_balance_mode = on<br>
>> > # Activate load balancing mode<br>
>> > # (change requires restart)<br>
>> > ignore_leading_white_space = on<br>
>> > # Ignore leading white spaces of each<br>
>> > query<br>
>> > white_function_list = ''<br>
>> > # Comma separated list of function<br>
>> names<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > black_function_list = 'currval,lastval,nextval,setval'<br>
>> > # Comma separated list of function<br>
>> names<br>
>> > # that write to database<br>
>> > # Regexp are accepted<br>
>> ><br>
>> > database_redirect_preference_list = ''<br>
>> > # comma separated list of pairs of database and node id.<br>
>> > # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'<br>
>> > # valid for streaming replicaton mode only.<br>
>> ><br>
>> > app_name_redirect_preference_list = ''<br>
>> > # comma separated list of pairs of app name and node id.<br>
>> > # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'<br>
>> > # valid for streaming replicaton mode only.<br>
>> > allow_sql_comments = off<br>
>> > # if on, ignore SQL comments when judging if load balance or<br>
>> > # query cache is possible.<br>
>> > # If off, SQL comments effectively prevent the judgment<br>
>> > # (pre 3.4 behavior).<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # MASTER/SLAVE MODE<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > master_slave_mode = on<br>
>> > # Activate master/slave mode<br>
>> > # (change requires restart)<br>
>> > master_slave_sub_mode = 'stream'<br>
>> > # Master/slave sub mode<br>
>> > # Valid values are combinations slony<br>
>> 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 neccessary even if you<br>
>> disable<br>
>> > streaming<br>
>> > # replication delay check by<br>
>> > sr_check_period = 0<br>
>> > sr_check_password = 'xxx'<br>
>> > # Password for streaming replication<br>
>> > check user<br>
>> > delay_threshold = 0<br>
>> > # Threshold before not dispatching<br>
>> query<br>
>> > 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<br>
>> > 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<br>
>> 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>
>> > # HEALTH CHECK<br>
>> ><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<br>
>> > health_check_password = 'xxx'<br>
>> > # Password for health check user<br>
>> > health_check_max_retries = 0<br>
>> > # Maximum number of times to retry a<br>
>> > failed health check before giving up.<br>
>> > health_check_retry_delay = 1<br>
>> > # Amount of time to wait (in seconds)<br>
>> > between retries.<br>
>> > connect_timeout = 10000<br>
>> > # Timeout value in milliseconds before<br>
>> > giving up to connect to backend.<br>
>> > # Default is 10000 ms (10 second). Flaky network user may want to<br>
>> increase<br>
>> > # the value. 0 means no timeout.<br>
>> > # Note that this value is not only used for health check,<br>
>> > # but also for ordinary conection to backend.<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # FAILOVER AND FAILBACK<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > failover_command = '/usr/local/etc/failover.sh %d %H<br>
>> > /var/log/pgpool/trigger/trigger_file0'<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<br>
>> 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<br>
>> 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<br>
>> > 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>
>> #------------------------------------------------------------------------------<br>
>> > # ONLINE RECOVERY<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > recovery_user = 'postgres'<br>
>> > # Online recovery user<br>
>> > recovery_password = 'xxx'<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<br>
>> start<br>
>> > up<br>
>> > # 0 means no wait<br>
>> > client_idle_limit_in_recovery = 0<br>
>> > # Client is disconnected after being<br>
>> idle<br>
>> > # for that many seconds in the second<br>
>> > stage<br>
>> > # of online recovery<br>
>> > # 0 means no disconnection<br>
>> > # -1 means immediate disconnection<br>
>> ><br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # WATCHDOG<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> ><br>
>> > # - Enabling -<br>
>> ><br>
>> > use_watchdog = on<br>
>> > # Activates watchdog<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 = 'SUYSevPrepDB02'<br>
>> > # Host name or IP address of this<br>
>> > 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<br>
>> > communication<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Virtual IP control Setting -<br>
>> ><br>
>> > delegate_IP = '192.168.140.112'<br>
>> > # delegate IP address<br>
>> > # If this is empty, virtual IP never<br>
>> > bring up.<br>
>> > # (change requires restart)<br>
>> > ifconfig_path = '/apachebin'<br>
>> > # ifconfig command path<br>
>> > # (change requires restart)<br>
>> > if_up_cmd = 'ifconfig eth1:0 inet $_IP_$ netmask 255.255.255.0'<br>
>> > # startup delegate IP command<br>
>> > # (change requires restart)<br>
>> > if_down_cmd = 'ifconfig eth1:0 down'<br>
>> > # shutdown delegate IP command<br>
>> > # (change requires restart)<br>
>> ><br>
>> > arping_path = '/apachebin'<br>
>> > # (change requires restart)<br>
>> ><br>
>> > arping_cmd = 'arping -I eth0 -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<br>
>> > memory<br>
>> > # when standby pgpool escalate to<br>
>> > active pgpool<br>
>> > # (= virtual IP holder).<br>
>> > # This should be off if client<br>
>> connects<br>
>> > to pgpool<br>
>> > # not using virtual IP.<br>
>> > # (change requires restart)<br>
>> > wd_escalation_command = ''<br>
>> > # Executes this command at escalation<br>
>> > 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<br>
>> > ('heartbeat' or 'query')<br>
>> > # (change requires restart)<br>
>> > wd_interval = 3<br>
>> > # lifecheck interval (sec) > 0<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # -- heartbeat mode --<br>
>> ><br>
>> > wd_heartbeat_port = 9694<br>
>> > # Port number for receiving heartbeat<br>
>> > signal<br>
>> > # (change requires restart)<br>
>> > wd_heartbeat_keepalive = 2<br>
>> > # Interval time of sending heartbeat<br>
>> > signal (sec)<br>
>> > # (change requires restart)<br>
>> > wd_heartbeat_deadtime = 30<br>
>> > # Deadtime interval for heartbeat<br>
>> > signal (sec)<br>
>> > # (change requires restart)<br>
>> > # Host name or IP address of<br>
>> > destination 0<br>
>> > # for sending heartbeat signal.<br>
>> > # (change requires restart)<br>
>> > # Port number of destination 0 for<br>
>> > sending<br>
>> > # heartbeat signal. Usually this is<br>
>> the<br>
>> > # same as wd_heartbeat_port.<br>
>> > # (change requires restart)<br>
>> > # Name of NIC device (such like<br>
>> 'eth0')<br>
>> > # used for sending/receiving<br>
>> heartbeat<br>
>> > # signal to/from destination 0.<br>
>> > # This works only when this is not<br>
>> 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<br>
>> > watchdog<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_dbname = 'template1'<br>
>> > # Database name connected for<br>
>> lifecheck<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_user = ''<br>
>> > # watchdog user monitoring pgpools in<br>
>> > lifecheck<br>
>> > # (change requires restart)<br>
>> > wd_lifecheck_password = ''<br>
>> > # Password for watchdog user in<br>
>> > lifecheck<br>
>> > # (change requires restart)<br>
>> ><br>
>> > # - Other pgpool Connection Settings -<br>
>> ><br>
>> > # Host name or IP address to connect<br>
>> to<br>
>> > for other pgpool 0<br>
>> > # (change requires restart)<br>
>> > # Port number for othet pgpool 0<br>
>> > # (change requires restart)<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>
>> #------------------------------------------------------------------------------<br>
>> > # OTHERS<br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > relcache_expire = 0<br>
>> > # Life time of relation cache in<br>
>> seconds.<br>
>> > # 0 means no cache expiration(the<br>
>> > default).<br>
>> > # The relation cache is used for cache<br>
>> > the<br>
>> > # query result against PostgreSQL<br>
>> system<br>
>> > # catalog to obtain various<br>
>> information<br>
>> > # including table structures or if<br>
>> it's a<br>
>> > # temporary table or not. The cache is<br>
>> > # maintained in a pgpool child local<br>
>> > memory<br>
>> > # and being kept as long as it<br>
>> survives.<br>
>> > # If someone modify the table by using<br>
>> > # ALTER TABLE or some such, the<br>
>> relcache<br>
>> > is<br>
>> > # not consistent anymore.<br>
>> > # For this purpose, cache_expiration<br>
>> > # controls the life time of the cache.<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<br>
>> in<br>
>> > SELECT statements.<br>
>> > # This initiates queries against<br>
>> system<br>
>> > catalog of primary/master<br>
>> > # thus increases load of master.<br>
>> > # If you are absolutely sure that your system never uses temporary<br>
>> tables<br>
>> > # and you want to save access to primary/master, you could turn this<br>
>> off.<br>
>> > # Default is on.<br>
>> ><br>
>> > check_unlogged_table = off<br>
>> > # If on, enable unlogged table check<br>
>> in<br>
>> > SELECT statements.<br>
>> > # This initiates queries against<br>
>> system<br>
>> > catalog of primary/master<br>
>> > # thus increases load of master.<br>
>> > # If you are absolutely sure that your<br>
>> > system never uses unlogged tables<br>
>> > # and you want to save access to<br>
>> > primary/master, you could turn this off.<br>
>> > # Default is on.<br>
>> ><br>
>> ><br>
>> #------------------------------------------------------------------------------<br>
>> > # IN MEMORY QUERY MEMORY CACHE<br>
>> ><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<br>
>> to<br>
>> > memcache<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > black_memqcache_table_list = ''<br>
>> > # Comma separated list of table names<br>
>> > not to memcache<br>
>> > # that don't write to database<br>
>> > # Regexp are accepted<br>
>> > ssl_key = ''<br>
>> > ssl_cert = ''<br>
>> > ssl_ca_cert = ''<br>
>> > ssl_ca_cert_dir = ''<br>
>> > log_error_verbosity = 'DEFAULT'<br>
>> > client_min_messages = 'notice'<br>
>> > log_min_messages = 'warning'<br>
>> > backend_hostname0 = 'SUYSevPrepDB01'<br>
>> > backend_port0 = 5432<br>
>> > backend_weight0 = 1<br>
>> > backend_data_directory0 = '/var/lib/pgsql/9.4/data'<br>
>> > backend_flag0= 'ALLOW_TO_FAILOVER'<br>
>> > backend_hostname1 = 'SUYSevPrepDB02'<br>
>> > backend_port1 = 5432<br>
>> > backend_weight1 = 1<br>
>> > backend_data_directory1 = '/var/lib/pgsql/9.4/data'<br>
>> > backend_flag1= 'ALLOW_TO_FAILOVER'<br>
>> > other_pgpool_hostname0 = 'SUYSevPrepDB01'<br>
>> > other_pgpool_port0 = 9999<br>
>> > other_wd_port0 = 9000<br>
>> > heartbeat_destination0 = 'SUYSevPrepDB01'<br>
>> > heartbeat_destination_port0 = 9694<br>
>> > heartbeat_device0 = ''<br>
>> ><br>
>> > # TYPE DATABASE USER ADDRESS METHOD<br>
>> ><br>
>> > # "local" is for Unix domain socket connections only<br>
>> > local all all md5<br>
>> > # IPv4 local connections:<br>
>> > host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> md5<br>
>> > host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>> > # IPv6 local connections:<br>
>> > # Allow replication connections from localhost, by a user with the<br>
>> > # replication privilege.<br>
>> > local replication postgres trust<br>
>> > host replication replication <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> trust<br>
>> > #host replication postgres ::1/128 trust<br>
>> ><br>
>> ><br>
>> > 2016-04-07 19:31 GMT-03:00 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>:<br>
>> ><br>
>> >> >>> *DETALLE: message length (12) in slot 1 does not match with slot<br>
>> 0(8)*<br>
>> >><br>
>> >> Probably a configuration mismatch in PostgreSQL server #0 and<br>
>> >> PostgreSQL server #1. From reading the message above, server #0 asks<br>
>> >> trust authentication (no password), while server #1 requires certain<br>
>> >> authentication (possibly md5). Showing full pgpool.conf and<br>
>> >> pg_hba.conf from both PostgreSQL servers will reveal this.<br>
>> >><br>
>> >> Best regards,<br>
>> >> --<br>
>> >> Tatsuo Ishii<br>
>> >> SRA OSS, Inc. Japan<br>
>> >> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
>> >><br>
>> >> > Lucas is the same error!!!!<br>
>> >> ><br>
>> >> ><br>
>> >> > Apr 7 16:14:24 localhost pgpool[14839]: [40-1] 2016-04-07 16:14:24:<br>
>> pid<br>
>> >> > 14839: # printf-style string to output at beginning of each log<br>
>> >> line.ERROR:<br>
>> >> > unable to read message length<br>
>> >> > Apr 7 16:14:24 localhost pgpool[14839]: [40-2] 2016-04-07 16:14:24:<br>
>> pid<br>
>> >> > 14839: # printf-style string to output at beginning of each log<br>
>> >> > line.DETAIL: message length (12) in slot 1 does not match with slot 0<br>
>> >> ><br>
>> >> > 2016-04-07 15:52 GMT-03:00 Lucas Luengas <<a href="mailto:lucasluengas@gmail.com">lucasluengas@gmail.com</a>>:<br>
>> >> ><br>
>> >> >> Hello<br>
>> >> >> You can check pgpool log and postgresql log when you run that psql<br>
>> >> command.<br>
>> >> >> Regards.<br>
>> >> >> On Apr 6, 2016 8:30 PM, "Daniel Gallo" <<a href="mailto:danielito.gallo@gmail.com">danielito.gallo@gmail.com</a>><br>
>> >> wrote:<br>
>> >> >><br>
>> >> >>> Dear I'm trying to run the following and I get the following error<br>
>> and<br>
>> >> I<br>
>> >> >>> can not figure out what the problem is , I could help ?<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> Any information that need be notified me and sent them<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> Thanks a lots!!!!!<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> -bash-4.2$ psql -h localhost -U postgres -p 5432<br>
>> >> >>><br>
>> >> >>> psql (9.4.4)<br>
>> >> >>><br>
>> >> >>> Digite «help» para obtener ayuda.<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> postgres=#<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> *-bash-4.2$ psql -h localhost -U postgres -p 9999*<br>
>> >> >>><br>
>> >> >>> *psql: ERROR: unable to read message length*<br>
>> >> >>><br>
>> >> >>> *DETALLE: message length (12) in slot 1 does not match with slot<br>
>> 0(8)*<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> Any idea?<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
</div></div>>> >> >>> *pg_hba.conf*<br>
<span class="">>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> # TYPE DATABASE USER ADDRESS<br>
>> METHOD<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> # "local" is for Unix domain socket connections only<br>
>> >> >>><br>
>> >> >>> local all all md5<br>
>> >> >>><br>
>> >> >>> # IPv4 local connections:<br>
>> >> >>><br>
>> >> >>> host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> md5<br>
>> >> >>><br>
>> >> >>> host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>> >> >>><br>
>> >> >>> # IPv6 local connections:<br>
>> >> >>><br>
>> >> >>> # Allow replication connections from localhost, by a user with the<br>
>> >> >>><br>
>> >> >>> # replication privilege.<br>
>> >> >>><br>
>> >> >>> local replication postgres<br>
>> trust<br>
>> >> >>><br>
>> >> >>> host replication replication <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a><br>
>> trust<br>
>> >> >>><br>
>> >> >>> #host replication postgres ::1/128<br>
>> trust<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
</span><span class="">>> >> >>> -rwxrw-r--. 1 apache apache 33283 abr 1 15:49 pgpool.conf<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> *pgpool.conf*<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
</span><span class="">>> >> >>> # - Authentication -<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> enable_pool_hba = on<br>
>> >> >>><br>
>> >> >>> # Use pool_hba.conf for client<br>
>> >> >>> authentication<br>
>> >> >>><br>
>> >> >>> pool_passwd = 'pool_passwd'<br>
>> >> >>><br>
>> >> >>> # File name of pool_passwd for<br>
>> md5<br>
>> >> >>> authentication.<br>
>> >> >>><br>
>> >> >>> # "" disables pool_passwd.<br>
>> >> >>><br>
>> >> >>> # (change requires restart)<br>
>> >> >>><br>
>> >> >>> authentication_timeout = 60<br>
>> >> >>><br>
>> >> >>> # Delay in seconds to complete<br>
>> >> client<br>
>> >> >>> authentication<br>
>> >> >>><br>
>> >> >>> # 0 means no timeout.<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
</span><span class="">>> >> >>> -rw-r--r--. 1 apache root 42 feb 29 18:28 pool_passwd<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> postgres:5c0435eee0f211f150e980e459151xxx<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> -rwxrw-r--. 1 root root 3295 mar 3 18:19 pool_hba.conf<br>
>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
</span>>> >> >>> # TYPE DATABASE USER CIDR-ADDRESS METHOD<br>
<span class="im HOEnZb">>> >> >>><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> # "local" is for Unix domain socket connections only<br>
>> >> >>><br>
>> >> >>> local all all md5<br>
>> >> >>><br>
>> >> >>> # IPv4 local connections:<br>
>> >> >>><br>
>> >> >>> host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> md5<br>
>> >> >>><br>
>> >> >>> host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>> >> >>><br>
</span><div class="HOEnZb"><div class="h5">>> >> >>> #host all all ::1/128 trust<br>
>> >> >>><br>
>> >> >>> _______________________________________________<br>
>> >> >>> pgpool-general mailing list<br>
>> >> >>> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
>> >> >>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>> >> >>><br>
>> >> >>><br>
>> >><br>
>><br>
</div></div></blockquote></div><br></div>