<div dir="ltr">Hi Lazaro,<div><br></div><div>pgpool can connect to the postgresql dbs with user pgpool and pass:</div><div>
<p class="gmail-p1"><span class="gmail-s1"> psql -U pgpool -W --dbname=postgres --host pgdb2 -c "\l"</span></p>
<p class="gmail-p1"><span class="gmail-s1">Password for user pgpool: </span></p>
<p class="gmail-p1"><span class="gmail-s1"> List of databases</span></p>
<p class="gmail-p1"><span class="gmail-s1"> Name | Owner | Encoding | Collate | Ctype | Access privileges </span></p>
<p class="gmail-p1"><span class="gmail-s1">-----------+------------+----------+-------------+-------------+-----------------------</span></p>
<p class="gmail-p1"> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | <br></p>
<p class="gmail-p1"><span class="gmail-s1"> repmgr | repmgr | UTF8 | en_US.UTF-8 | en_US.UTF-8 | </span></p>
<p class="gmail-p1"><span class="gmail-s1"> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +</span></p>
<p class="gmail-p1"><span class="gmail-s1"> | | | | | postgres=CTc/postgres</span></p>
<p class="gmail-p1"><span class="gmail-s1"> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +</span></p>
<p class="gmail-p1"><br></p>
<p class="gmail-p1"><span class="gmail-s1"> test2 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | </span></p>
<p class="gmail-p1"><span class="gmail-s1"> test3 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | </span></p><p class="gmail-p1"><span class="gmail-s1"><br></span></p><p class="gmail-p1">Im doing an insert query. </p><p class="gmail-p1">Ty</p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jan 16, 2017 at 6:01 PM, Lazaro Garcia <span dir="ltr"><<a href="mailto:lazaro3487@gmail.com" target="_blank">lazaro3487@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 lang="ES" link="#0563C1" vlink="#954F72"><div class="m_-6120837070149274410WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">What about postgresql node info in pgpool ? <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Can pgpool connect to postgresql servers throw pgpool user with pool password?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:9.5pt">sr_check_user = 'pgpool'<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:9.5pt"> # Streaming replication check user<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:9.5pt"> # This is neccessary even if you disable streaming<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:9.5pt"> # replication delay check by sr_check_period = 0<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:9.5pt">sr_check_password = 'pool'<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Is the write query an Insert, Update or Delete? The write query is any select over an store procedure?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">De:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.<wbr>net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-<wbr>bounces@pgpool.net</a>] <b>En nombre de </b>ahmad milani<br><b>Enviado el:</b> lunes, 16 de enero de 2017 5:32<br><b>Para:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><b>Asunto:</b> [pgpool-general: 5235] PGPOOL lb issue<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal"><span style="font-size:9.5pt">Hi,</span><u></u><u></u></p><div><p class="MsoNormal"><span style="font-size:9.5pt"><br clear="all"><u></u><u></u></span></p><div><p class="MsoNormal"><span style="font-size:9.5pt">I have in issue with pgpool2 and cannot figure out why!!!! my setup is as follows:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">singe pgpool to do LB for me<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">master slave postgress<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">The issue is as follows, when i send read queries via the pgpool everything is fine, load get distributed between and master and salve.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">but when im doing a query that writes to the database the pgpool again uses both slave and master and it yeilds error on queries sent to slave.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">I have installed 96 on centos.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><div><p class="MsoNormal"><span style="font-size:9.5pt"># ----------------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># pgPool-II configuration file<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># ----------------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># This file consists of lines of the form:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># name = value<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># Whitespace may be used. Comments are introduced with "#" anywhere on a line.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># The complete list of parameter names and allowed values can be found in the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># pgPool-II documentation.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># This file is read on server startup and when the server receives a SIGHUP<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># signal. If you edit the file on a running system, you have to SIGHUP the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># server for the changes to take effect, or use "pgpool reload". Some<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># parameters, which are marked below, require a server shutdown and restart to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># take effect.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># CONNECTIONS<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - pgpool Connection Settings -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">listen_addresses = '*'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address to listen on:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # '*' for all, '' for no TCP/IP connections<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">port = 5432<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">socket_dir = '/tmp'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Unix domain socket path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # The Debian package defaults to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # /var/run/postgresql<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - pgpool Communication Manager Connection Settings -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">pcp_listen_addresses = '*'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address for pcp process to listen on:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # '*' for all, '' for no TCP/IP connections<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">pcp_port = 9898<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number for pcp<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">pcp_socket_dir = '/tmp'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Unix domain socket path for pcp<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # The Debian package defaults to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # /var/run/postgresql<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">listen_backlog_multiplier = 2<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Set the backlog parameter of listen(2) to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # num_init_children * listen_backlog_multiplier.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">serialize_accept = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # whether to serialize accept() call to avoid thundering herd problem<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Backend Connection Settings -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_hostname0 = 'pgdb1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address to connect to for backend 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_port0 = 5432<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number for backend 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_weight0 = 1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Weight for backend 0 (only in load balancing mode)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_data_directory0 = '/var/lib/pgsql/9.5/data'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Data directory for backend 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_flag0 = 'ALLOW_TO_FAILOVER'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Controls various backend behavior<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_hostname1 = 'pgdb2'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_port1 = 5432<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_weight1 = 1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_data_directory1 = '/var/lib/pgsql/9.5/data'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">backend_flag1 = 'ALLOW_TO_FAILOVER'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Authentication -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">enable_pool_hba = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Use pool_hba.conf for client authentication<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">pool_passwd = 'pool_passwd'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # File name of pool_passwd for md5 authentication.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # "" disables pool_passwd.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">authentication_timeout = 60<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Delay in seconds to complete client authentication<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no timeout.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - SSL Connections -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">ssl = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Enable SSL support<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#ssl_key = './server.key'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Path to the SSL private key file<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#ssl_cert = './server.cert'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Path to the SSL public certificate file<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#ssl_ca_cert = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Path to a single PEM format file<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # containing CA root certificate(s)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#ssl_ca_cert_dir = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Directory containing CA root certificate(s)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># POOLS<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Concurrent session and pool size -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">num_init_children = 32<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Number of concurrent sessions allowed<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">max_pool = 4<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Number of connection pool caches per connection<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Life time -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">child_life_time = 300<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Pool exits after being idle for this many seconds<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">child_max_connections = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Pool exits after receiving that many connections<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no exit<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">connection_life_time = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Connection to backend closes after being idle for this many seconds<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no close<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">client_idle_limit = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Client is disconnected after being idle for that many seconds<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (even inside an explicit transactions!)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no disconnection<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># LOGS<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Where to log -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_destination = 'stderr'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Where to log<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Valid values are combinations of stderr,<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and syslog. Default to stderr.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - What to log -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_connections = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Log connections<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_hostname = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Hostname will be shown in ps status<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and in logs if connections are logged<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_statement = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Log all statements<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_per_node_statement = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Log all statements<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # with node and backend informations<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">log_standby_delay = 'if_over_threshold'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Log standby delay<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Valid values are combinations of always,<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # if_over_threshold, none<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Syslog specific -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">syslog_facility = 'LOCAL0'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Syslog local facility. Default to LOCAL0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">syslog_ident = 'pgpool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Syslog program identification string<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Default to 'pgpool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Debug -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">debug_level = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Debug message verbosity level<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no message, 1 or more mean verbose<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#log_error_verbosity = default # terse, default, or verbose messages<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#client_min_messages = notice # values in order of decreasing detail:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug5<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug4<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug3<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug2<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # log<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # notice<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # warning<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # error<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#log_min_messages = warning # values in order of decreasing detail:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug5<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug4<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug3<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug2<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # debug1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # info<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # notice<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # warning<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # error<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # log<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # fatal<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # panic<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># FILE LOCATIONS<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">pid_file_name = '/var/run/pgpool-II-95/pgpool.<wbr>pid'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # PID file name<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">logdir = '/tmp'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Directory of pgPool status file<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># CONNECTION POOLING<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">connection_cache = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Activate connection pools<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Semicolon separated list of queries<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # to be issued at the end of a session<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # The default is for 8.3 and later<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">reset_query_list = 'ABORT; DISCARD ALL'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # The following one is for 8.2 and before<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># REPLICATION MODE<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">replication_mode = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Activate replication mode<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">replicate_select = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Replicate SELECT statements<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # when in replication mode<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # replicate_select is higher priority than<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # load_balance_mode.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">insert_lock = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Automatically locks a dummy row or a table<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # with INSERT statements to keep SERIAL data<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # consistency<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Without SERIAL, no lock will be issued<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">lobj_lock_table = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # When rewriting lo_creat command in<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # replication mode, specify table name to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # lock<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Degenerate handling -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">replication_stop_on_mismatch = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # On disagreement with the packet kind<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # sent from backend, degenerate the node<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # which is most likely "minority"<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If off, just force to exit this session<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">failover_if_affected_tuples_<wbr>mismatch = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # On disagreement with the number of affected<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # tuples in UPDATE/DELETE queries, then<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # degenerate the node which is most likely<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # "minority".<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If off, just abort the transaction to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # keep the consistency<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># LOAD BALANCING MODE<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">load_balance_mode = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Activate load balancing mode<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">ignore_leading_white_space = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Ignore leading white spaces of each query<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">white_function_list = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Comma separated list of function names<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # that don't write to database<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Regexp are accepted<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">black_function_list = 'currval,lastval,nextval,<wbr>setval'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Comma separated list of function names<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # that write to database<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Regexp are accepted<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">database_redirect_preference_<wbr>list = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # comma separated list of pairs of database and node id.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # example: postgres:primary,mydb[0-4]:1,<wbr>mydb[5-9]:2'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # valid for streaming replicaton mode only.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">app_name_redirect_preference_<wbr>list = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # comma separated list of pairs of app name and node id.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # example: 'psql:primary,myapp[0-4]:1,<wbr>myapp[5-9]:standby'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # valid for streaming replicaton mode only.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">allow_sql_comments = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # if on, ignore SQL comments when judging if load balance or<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # query cache is possible.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If off, SQL comments effectively prevent the judgment<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (pre 3.4 behavior).<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># MASTER/SLAVE MODE<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">master_slave_mode = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Activate master/slave mode<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">master_slave_sub_mode = 'stream'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Master/slave sub mode<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Valid values are combinations slony or<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # stream. Default is slony.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Streaming -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">sr_check_period = 10<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Streaming replication check period<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Disabled (0) by default<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">sr_check_user = 'pgpool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Streaming replication check user<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # This is neccessary even if you disable streaming<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # replication delay check by sr_check_period = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">sr_check_password = 'pool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Password for streaming replication check user<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">sr_check_database = 'postgres'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Database name for streaming replication check<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">delay_threshold = 10000000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Threshold before not dispatching query to standby node<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Unit is in bytes<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Disabled (0) by default<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Special commands -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">follow_master_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes this command after master failover<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Special values:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %d = node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %h = host name<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %p = port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %D = database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %m = new master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %H = hostname of the new master node<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %M = old master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %P = old primary node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %r = new master port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %R = new master database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %% = '%' character<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># HEALTH CHECK<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_period = 10<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Health check period<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Disabled (0) by default<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_timeout = 20<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Health check timeout<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no timeout<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_user = 'pgpool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Health check user<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_password = 'pool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Password for health check user<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_database = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Database name for health check. If '', tries 'postgres' frist, <u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_max_retries = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Maximum number of times to retry a failed health check before giving up.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">health_check_retry_delay = 1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Amount of time to wait (in seconds) between retries.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">connect_timeout = 10000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Timeout value in milliseconds before giving up to connect to backend.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Default is 10000 ms (10 second). Flaky network user may want to increase<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # the value. 0 means no timeout.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Note that this value is not only used for health check,<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # but also for ordinary conection to backend.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># FAILOVER AND FAILBACK<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">failover_command = '/etc/pgpool-II-95/failover.sh %d %H'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes this command at failover<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Special values:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %d = node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %h = host name<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %p = port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %D = database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %m = new master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %H = hostname of the new master node<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %M = old master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %P = old primary node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %r = new master port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %R = new master database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %% = '%' character<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">failback_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes this command at failback.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Special values:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %d = node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %h = host name<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %p = port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %D = database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %m = new master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %H = hostname of the new master node<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %M = old master node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %P = old primary node id<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %r = new master port number<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %R = new master database cluster path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # %% = '%' character<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">fail_over_on_backend_error = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Initiates failover when reading/writing to the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # backend communication socket fails<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If set to off, pgpool will report an<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # error and disconnect the session.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">search_primary_node_timeout = 300<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Timeout in seconds to search for the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # primary node when a failover occurs.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no timeout, keep searching<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # for a primary node forever.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># ONLINE RECOVERY<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">recovery_user = 'pgpool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Online recovery user<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">recovery_password = 'pool'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Online recovery password<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">recovery_1st_stage_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes a command in first stage<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">recovery_2nd_stage_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes a command in second stage<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">recovery_timeout = 90<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Timeout in seconds to wait for the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # recovering node's postmaster to start up<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no wait<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">client_idle_limit_in_recovery = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Client is disconnected after being idle<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # for that many seconds in the second stage<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # of online recovery<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no disconnection<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # -1 means immediate disconnection<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># WATCHDOG<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Enabling -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">use_watchdog = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Activates watchdog<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># -Connection to up stream servers -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">trusted_servers = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # trusted server list which are used<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # to confirm network connection<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (hostA,hostB,hostC,...)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">ping_path = '/bin'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # ping command path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Watchdog communication Settings -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_hostname = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address of this watchdog<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_port = 9000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # port number for watchdog service<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_priority = 1<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># priority of this watchdog in leader election<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_authkey = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Authentication key for watchdog communication<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_ipc_socket_dir = '/tmp'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># Unix domain socket path for watchdog IPC socket<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># The Debian package defaults to<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># /var/run/postgresql<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Virtual IP control Setting -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">delegate_IP = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # delegate IP address<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If this is empty, virtual IP never bring up. <u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">if_cmd_path = '/sbin'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # path to the directory where if_up/down_cmd exists <u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">if_up_cmd = 'ip addr add $_IP_$/24 dev eth0 label eth0:0'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # startup delegate IP command<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">if_down_cmd = 'ip addr del $_IP_$/24 dev eth0'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # shutdown delegate IP command<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">arping_path = '/usr/sbin'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # arping command path<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">arping_cmd = 'arping -U $_IP_$ -w 1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # arping command<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Behaivor on escalation Setting -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">clear_memqcache_on_escalation = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Clear all the query cache on shared memory<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # when standby pgpool escalate to active pgpool<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (= virtual IP holder).<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # This should be off if client connects to pgpool<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # not using virtual IP.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_escalation_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Executes this command at escalation on new active pgpool.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_de_escalation_command = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># Executes this command when master pgpool resigns from being master.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Lifecheck Setting -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># -- common --<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># if any interface from the list is active the watchdog will<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># consider the network is fine<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># 'any' to enable monitoring on all interfaces except loopback<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># '' to disable monitoring<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_lifecheck_method = 'heartbeat'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_interval = 10<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # lifecheck interval (sec) > 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># -- heartbeat mode --<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_heartbeat_port = 9694<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number for receiving heartbeat signal<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_heartbeat_keepalive = 2<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Interval time of sending heartbeat signal (sec)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_heartbeat_deadtime = 30<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Deadtime interval for heartbeat signal (sec)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">heartbeat_destination0 = 'host0_ip1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address of destination 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # for sending heartbeat signal.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">heartbeat_destination_port0 = 9694 <u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number of destination 0 for sending<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # heartbeat signal. Usually this is the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # same as wd_heartbeat_port.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">heartbeat_device0 = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Name of NIC device (such like 'eth0')<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # used for sending/receiving heartbeat<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # signal to/from destination 0.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # This works only when this is not empty<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and pgpool has root privilege.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#heartbeat_destination1 = 'host0_ip2'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#heartbeat_destination_port1 = 9694<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#heartbeat_device1 = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># -- query mode --<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_life_point = 3<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # lifecheck retry times<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_lifecheck_query = 'SELECT 1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # lifecheck query to pgpool from watchdog<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_lifecheck_dbname = 'template1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Database name connected for lifecheck<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_lifecheck_user = 'nobody'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # watchdog user monitoring pgpools in lifecheck<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">wd_lifecheck_password = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Password for watchdog user in lifecheck<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># - Other pgpool Connection Settings -<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_pgpool_hostname0 = 'host0'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Host name or IP address to connect to for other pgpool 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_pgpool_port0 = 5432<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number for othet pgpool 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_wd_port0 = 9000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Port number for othet watchdog 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_pgpool_hostname1 = 'host1'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_pgpool_port1 = 5432<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#other_wd_port1 = 9000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># OTHERS<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">relcache_expire = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Life time of relation cache in seconds.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means no cache expiration(the default).<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # The relation cache is used for cache the<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # query result against PostgreSQL system<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # catalog to obtain various information<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # including table structures or if it's a<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # temporary table or not. The cache is<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # maintained in a pgpool child local memory<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and being kept as long as it survives.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If someone modify the table by using<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # ALTER TABLE or some such, the relcache is<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # not consistent anymore.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # For this purpose, cache_expiration<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # controls the life time of the cache.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">relcache_size = 256<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Number of relation cache<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # entry. If you see frequently:<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # "pool_search_relcache: cache replacement happend"<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # in the pgpool log, you might want to increate this number.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">check_temp_table = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If on, enable temporary table check in SELECT statements.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # This initiates queries against system catalog of primary/master<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # thus increases load of master.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If you are absolutely sure that your system never uses temporary tables<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and you want to save access to primary/master, you could turn this off.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Default is on.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">check_unlogged_table = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If on, enable unlogged table check in SELECT statements.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # This initiates queries against system catalog of primary/master<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # thus increases load of master.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If you are absolutely sure that your system never uses unlogged tables<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # and you want to save access to primary/master, you could turn this off.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Default is on.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"># IN MEMORY QUERY MEMORY CACHE<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memory_cache_enabled = off<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If on, use the memory cache functionality, off by default<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_method = 'shmem'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Cache storage method. either 'shmem'(shared memory) or<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 'memcached'. 'shmem' by default<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_memcached_host = 'localhost'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Memcached host name or IP address. Mandatory if<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # memqcache_method = 'memcached'.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Defaults to localhost.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_memcached_port = 11211<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Memcached port number. Mondatory if memqcache_method = 'memcached'.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Defaults to 11211.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_total_size = 67108864<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Total memory size in bytes for storing memory cache.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Mandatory if memqcache_method = 'shmem'.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Defaults to 64MB.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_max_num_cache = 1000000<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Total number of cache entries. Mandatory<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # if memqcache_method = 'shmem'.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Each cache entry consumes 48 bytes on shared memory.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Defaults to 1,000,000(45.8MB).<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_expire = 0<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Memory cache entry life time specified in seconds.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # 0 means infinite life time. 0 by default.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_auto_cache_<wbr>invalidation = on<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # If on, invalidation of query cache is triggered by corresponding<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # DDL/DML/DCL(and memqcache_expire). If off, it is only triggered<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # by memqcache_expire. on by default.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_maxcache = 409600<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Maximum SELECT result size in bytes.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Must be smaller than memqcache_cache_block_size. Defaults to 400KB.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_cache_block_size = 1048576<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Defaults to 1MB.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">memqcache_oiddir = '/var/log/pgpool/oiddir'<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> <span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-apple-tab-span"> </span> # Temporary work directory to record table oids<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # (change requires restart)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">white_memqcache_table_list = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Comma separated list of table names to memcache<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # that don't write to database<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Regexp are accepted<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt">black_memqcache_table_list = ''<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Comma separated list of table names not to memcache<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # that don't write to database<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:9.5pt"> # Regexp are accepted<u></u><u></u></span></p></div></div><div><p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p></div><div><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt">---------+----------+------+--<wbr>------+-----------+---------+-<wbr>-----------</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt"> 0 | pgdb1 | 5432 | 2 | 0.500000 | primary | 10581</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt"> 1 | pgdb2 | 5432 | 2 | 0.500000 | standby | 2351</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span style="font-size:9.5pt"><u></u> <u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt">Role | Name | Upstream | Connection String</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt">----------+-------|----------|<wbr>------------------------------<wbr>-------</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt"> standby | pgdb2 | | host=pgdb2 user=repmgr dbname=repmgr</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt">* master | pgdb1 | | host=pgdb1 user=repmgr dbname=repmgr</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span style="font-size:9.5pt"><u></u> <u></u></span></p><p class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-p1"><span class="m_-6120837070149274410gmail-m1313661913095189041gmail-m-8072961440093362156gmail-s1"><span style="font-size:9.5pt">The errors I see on the web server:</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p><table class="m_-6120837070149274410MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="660" style="width:495.0pt;border-collapse:collapse"><tbody><tr id="m_-6120837070149274410gmail-comment-70462350"><td valign="top" style="border:none;border-bottom:solid #eff0f1 1.0pt;padding:4.5pt 4.5pt 4.5pt 0cm;border-top-style:initial;border-right-style:initial;border-left-style:initial;border-top-color:initial;border-right-color:initial;border-left-color:initial"><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#242729;border:none windowtext 1.0pt;padding:0cm"><br><span class="m_-6120837070149274410gmail-comment-copy">PreventCommandIfReadOnly </span></span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#242729"><u></u><u></u></span></p></div><div><p class="MsoNormal"><span class="m_-6120837070149274410gmail-comment-copy"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#242729;border:none windowtext 1.0pt;padding:0cm">cannot execute SELECT in a read-only transaction</span></span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#242729"><u></u><u></u></span></p></div></td></tr></tbody></table></div></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Ahmad Milani</div>
</div>