<div dir="ltr">Hi i think you can script that. In pgpool.conf you should have something like "recover_command" but you have to know the failed node number maybe option like %d should exists to get this number.</div><div class="gmail_extra"><br><div class="gmail_quote">2016-10-13 14:53 GMT+02:00 Dylan Luong <span dir="ltr"><<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div class="m_4245016435002446766WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks. Does that mean every time where there is temp disconnection (ie network issue) we have to manually run a detach_node and attach_node?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Joffrey Dupire [mailto:<a href="mailto:joffrey.dupire@morning.com" target="_blank">joffrey.dupire@<wbr>morning.com</a>]
<br>
<b>Sent:</b> Thursday, 13 October 2016 9:44 PM<br>
<b>To:</b> Dylan Luong<br>
<b>Cc:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> Re: [pgpool-general: 5042] Re: pgpool fail to load balance after database restart<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal" style="margin-left:36.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Hi,<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">You have to use detach_node command and attach_node<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u></u> <u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">2016-10-13 12:52 GMT+02:00 Dylan Luong <<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>>:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">More info:</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">For scenario 1, I tried restarting pgpool with debug (pgpool -n -d > pgpool2.log 2>&1), I can see in the log file that the health check working but it reports that the slave node
0 down (status 3) even though it is up.</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: health check: clearing alarm</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: doing health check against database:postgres user:postgres</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: Backend DB node 0 status is 3</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: Backend DB node 1 status is 2</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: Trying to make persistent DB connection to backend node 1 having status 2</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: pool_read: read 13 bytes from backend 0</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: authenticate kind = 5</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: pool_write: to backend: 0 kind:p</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: pool_read: read 331 bytes from backend 0</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: authenticate kind = 0</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: authenticate backend: key data received</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: authenticate backend: transaction state: I</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">2016-10-13 21:11:42: pid 6618: DEBUG: persistent DB connection to backend node 1 having status 2 is successful</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Why is it reporting its down. Its definitely up and receiving wal replication from the Master node1.</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:72.0pt">
<b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","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>On Behalf Of </b>Dylan Luong<br>
<b>Sent:</b> Tuesday, 11 October 2016 6:06 PM<br>
<b>To:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 5038] pgpool fail to load balance after database restart</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:72.0pt">
<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Hi,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I am new to pgpool. I have just installed pgpool and configured Master/Slave mode with “stream” sub_mode. I have enabled load balance as that is the main feature we want test out. I have enabled
Health Check. The load balance appears to work as I can see connections to both Master and Slave database.
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pgpool is installed on a separate server. (linux Redhat 6)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">ie: server1 = pgpool</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">server2 = Master</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">server3= Slave</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">(wal replication)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I tested two scenarios and it failing:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">1.</span><span style="font-size:7.0pt">
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">When I stop/start the slave database, pgpool stops load balancing. It looks like it doesn’t know that it available again after the slave comes backup online. Even after I restart pgpool
it doesn’t load balance. It just sends all queries to the Master.</span><u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">2.</span><span style="font-size:7.0pt">
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I tried shutting down slave db and then shut down master db (no failover) and restart master db and restart slave, pgpool failed to reconnect to the master or the slave. I get database
unavailable errors. However, if I restart pgpool for this scenario, its all fine.</span><u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">It appears that pgpool is not doing the healthcheck correctly?? Or have I missed something here??</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Here are my main pgpool.conf changes:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># CONNECTIONS</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - pgpool Connection Settings -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">listen_addresses = '*'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Host name or IP address to listen on:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # '*' for all, '' for no TCP/IP connections</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#port = 9999</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">port = 5432</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Port number</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">socket_dir = '/var/run/postgresql'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Unix domain socket path</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # The Debian package defaults to</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # /var/run/postgresql</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">listen_backlog_multiplier = 2</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Set the backlog parameter of listen(2) to</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # num_init_children * listen_backlog_multiplier.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">serialize_accept = off</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # whether to serialize accept() call to avoid thundering herd problem</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - pgpool Communication Manager Connection Settings -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_listen_addresses = '*'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Host name or IP address for pcp process to listen on:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # '*' for all, '' for no TCP/IP connections</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_port = 9898</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Port number for pcp</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_socket_dir = '/var/run/postgresql'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Unix domain socket path for pcp</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # The Debian package defaults to</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # /var/run/postgresql</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Backend Connection Settings -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_hostname0 = '10.69.20.11'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Host name or IP address to connect to for backend 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_port0 = 5432</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Port number for backend 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_weight0 = 1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Weight for backend 0 (only in load balancing mode)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_data_directory0 = '/var/lib/pgsql/9.5/data'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Data directory for backend 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_flag0 = 'ALLOW_TO_FAILOVER'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Controls various backend behavior</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_hostname1 = '10.68.20.11'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_port1 = 5432</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_weight1 = 1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_data_directory1 = '/var/lib/pgsql/9.5/data'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_flag1 = 'ALLOW_TO_FAILOVER'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># POOLS</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Concurrent session and pool size -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">num_init_children = 32</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Number of concurrent sessions allowed</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">max_pool = 4</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Number of connection pool caches per connection</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Life time -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">child_life_time = 300</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Pool exits after being idle for this many seconds</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">child_max_connections = 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Pool exits after receiving that many connections</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # 0 means no exit</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connection_life_time = 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Connection to backend closes after being idle for this many seconds</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # 0 means no close</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">client_idle_limit = 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Client is disconnected after being idle for that many seconds</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (even inside an explicit transactions!)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # 0 means no disconnection</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># CONNECTION POOLING</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connection_cache = on</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Activate connection pools</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Semicolon separated list of queries</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # to be issued at the end of a session</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # The default is for 8.3 and later</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">reset_query_list = 'ABORT; DISCARD ALL'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # The following one is for 8.2 and before</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># LOAD BALANCING MODE</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">load_balance_mode = on</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Activate load balancing mode</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">ignore_leading_white_space = on</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Ignore leading white spaces of each query</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">white_function_list = ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Comma separated list of function names</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # that don't write to database</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Regexp are accepted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#black_function_list = 'nextval,setval,nextval,<wbr>setval'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">black_function_list = 'currval,lastval,nextval,<wbr>setval'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Comma separated list of function names</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # that write to database</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Regexp are accepted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">database_redirect_preference_<wbr>list = ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # comma separated list of pairs of database and node id.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # example: postgres:primary,mydb[0-4]:1,<wbr>mydb[5-9]:2'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # valid for streaming replicaton mode only.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">app_name_redirect_preference_<wbr>list = ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # comma separated list of pairs of app name and node id.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # example: 'psql:primary,myapp[0-4]:1,<wbr>myapp[5-9]:standby'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # valid for streaming replicaton mode only.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">allow_sql_comments = off</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # if on, ignore SQL comments when judging if load balance or</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # query cache is possible.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # If off, SQL comments effectively prevent the judgment</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # (pre 3.4 behavior).</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># MASTER/SLAVE MODE</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">master_slave_mode = on</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Activate master/slave mode</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">master_slave_sub_mode = 'stream'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Master/slave sub mode</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Valid values are combinations slony or</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # stream. Default is slony.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # (change requires restart)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Streaming -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_period = 5</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Streaming replication check period</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Disabled (0) by default</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_user = 'postgres'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Streaming replication check user</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # This is necessary even if you disable</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # streaming replication delay check with</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # sr_check_period = 0</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_password = 'xxxxxxxxxxxxxxxx'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Password for streaming replication check user</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_database = 'postgres'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Database name for streaming replication check</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">delay_threshold = 10000000</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Threshold before not dispatching query to standby node</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Unit is in bytes</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Disabled (0) by default</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Special commands -</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">follow_master_command = ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Executes this command after master failover</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Special values:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %d = node id</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %h = host name</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %p = port number</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %D = database cluster path</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %m = new master node id</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %H = hostname of the new master node</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %M = old master node id</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %P = old primary node id</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %r = new master port number</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %R = new master database cluster path</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # %% = '%' character</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># HEALTH CHECK</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#-----------------------------<wbr>------------------------------<wbr>-------------------</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_period = 40</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Health check period</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Disabled (0) by default</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_timeout = 10</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Health check timeout</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # 0 means no timeout</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_user = 'postgres'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Health check user</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_password = 'xxxxxxxxxxxxxxxxxx'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Password for health check user</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_database = ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Database name for health check. If '', tries 'postgres' frist, then 'template1'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_max_retries = 3</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Maximum number of times to retry a failed health check before giving up.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_retry_delay = 1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Amount of time to wait (in seconds) between retries.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connect_timeout = 10000</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> # Timeout value in milliseconds before giving up to connect to backend.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # Default is 10000 ms (10 second). Flaky network user may want to increase</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # the value. 0 means no timeout.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # Note that this value is not only used for health check,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <wbr> <wbr> # but also for ordinary conection to backend.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Thanks.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#888888">Dylan</span><span style="color:#888888"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#888888"> </span><span style="color:#888888"><u></u><u></u></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-right:0cm;margin-bottom:12.0pt;margin-left:36.0pt">
<br>
______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u></u> <u></u></p>
</div>
<p class="MsoNormal" style="margin-left:36.0pt">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><b><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#444444">Joffrey DUPIRE</span></b><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#666666">Network Guru</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="mailto:prenom.nom@morning.com" target="_blank"><span style="color:#1155cc">joffrey.dupire@morning.com</span></a></span></u><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#666666"> </span><span style="font-size:9.5pt;color:#888888"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><u><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="http://morning.com/" target="_blank"><span style="color:#1155cc">morning </span></a></span></u><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#888888">| </span><u><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="http://up.morning.com/" target="_blank"><span style="color:#1155cc">up</span></a></span></u><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#888888"> | </span><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="http://corpo.morning.com/" target="_blank"><span style="color:#1155cc">corpo</span></a></span><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#888888"> </span><span style="font-size:9.5pt;color:#888888"><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><img border="0" width="200" height="39" id="m_4245016435002446766_x0000_i1025" src="http://cobanking.fr/wp-content/uploads/2016/06/Gif_Signature_Morning.gif"><u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="https://twitter.com/morning_com" target="_blank"><span style="color:#1155cc">Twitter</span></a> </span><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#888888">| </span><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc"><a href="https://www.facebook.com/morning.fr" target="_blank"><span style="color:#1155cc">Facebook</span></a> </span><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#888888">| </span><a href="https://www.linkedin.com/company/payname" target="_blank"><span style="font-size:9.5pt;font-family:"Trebuchet MS","sans-serif";color:#1155cc">Linkedin</span></a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div><font color="#444444" face="trebuchet ms, sans-serif"><span style="font-size:13.3333px"><b>Joffrey DUPIRE</b></span></font></div><div><font color="#666666" face="trebuchet ms, sans-serif"><span style="font-size:13.3333px">Network Guru</span></font></div><div style="font-size:12.8px;color:rgb(136,136,136)"><u style="font-family:"trebuchet ms",sans-serif;font-size:12.8px"><span style="font-size:9.5pt;color:rgb(17,85,204)"><a href="mailto:prenom.nom@morning.com" style="color:rgb(17,85,204)" target="_blank">joffrey.dupire@morning.com</a></span></u><span style="font-family:"trebuchet ms",sans-serif;font-size:9.5pt;color:rgb(102,102,102)"> </span></div><div style="font-size:12.8px;color:rgb(136,136,136)"><u style="font-family:"trebuchet ms",sans-serif;font-size:12.8px"><span style="font-size:10pt;color:rgb(17,85,204)"><a href="http://morning.com/" style="color:rgb(17,85,204)" target="_blank">morning </a></span></u><span style="font-family:"trebuchet ms",sans-serif;font-size:9.5pt">| </span><u style="font-family:"trebuchet ms",sans-serif;font-size:12.8px"><span style="font-size:9.5pt;color:rgb(17,85,204)"><a href="http://up.morning.com/" style="color:rgb(17,85,204)" target="_blank">up</a></span></u><span style="font-family:"trebuchet ms",sans-serif;font-size:9.5pt"> | <span style="color:rgb(17,85,204)"><a href="http://corpo.morning.com/" style="color:rgb(17,85,204)" target="_blank">corpo</a></span></span><span style="font-family:"trebuchet ms",sans-serif;font-size:9.5pt"> </span></div></div><img src="http://cobanking.fr/wp-content/uploads/2016/06/Gif_Signature_Morning.gif" width="200" height="39"><br><div><span style="font-family:"trebuchet ms",sans-serif;font-size:10pt;color:rgb(17,85,204)"><a href="https://twitter.com/morning_com" style="color:rgb(17,85,204)" target="_blank">Twitter</a> </span><span style="color:rgb(136,136,136);font-family:"trebuchet ms",sans-serif;font-size:12.6667px">| </span><span style="font-family:"trebuchet ms",sans-serif;font-size:12.6667px;color:rgb(17,85,204)"><a href="https://www.facebook.com/morning.fr" style="color:rgb(17,85,204)" target="_blank">Facebook</a> </span><span style="color:rgb(136,136,136);font-family:"trebuchet ms",sans-serif;font-size:12.6667px">| </span><a href="https://www.linkedin.com/company/payname" style="color:rgb(17,85,204);font-family:"trebuchet ms",sans-serif;font-size:12.6667px" target="_blank">Linkedin</a><br></div></div></div>
</div>