<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-AU;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Is this a bug of pgpool or is it meant to be like that where we need some manual intervention in this situation?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></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:joffrey.dupire@morning.com]
<br>
<b>Sent:</b> Friday, 14 October 2016 12:32 AM<br>
<b>To:</b> Dylan Luong<br>
<b>Cc:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-general: 5042] Re: pgpool fail to load balance after database restart<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">2016-10-13 14:53 GMT+02:00 Dylan Luong <<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>>:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<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?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;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""> Joffrey Dupire [mailto:<a href="mailto:joffrey.dupire@morning.com" target="_blank">joffrey.dupire@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</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
Hi,<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
You have to use detach_node command and attach_node<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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>>:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">More info:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.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.net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-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><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Hi,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pgpool is installed on a separate server. (linux Redhat 6)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">ie: server1 = pgpool</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">server2 = Master</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">server3= Slave</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">(wal replication)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I tested two scenarios and it failing:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.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><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.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><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Here are my main pgpool.conf changes:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># CONNECTIONS</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - pgpool Connection Settings -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">listen_addresses = '*'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Host name or IP address to listen on:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # '*' for all, '' for no TCP/IP connections</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#port = 9999</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">port = 5432</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Port number</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">socket_dir = '/var/run/postgresql'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Unix domain socket path</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # The Debian package defaults to</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # /var/run/postgresql</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">listen_backlog_multiplier = 2</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Set the backlog parameter of listen(2) to</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # num_init_children * listen_backlog_multiplier.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">serialize_accept = off</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # whether to serialize accept() call to avoid thundering herd problem</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - pgpool Communication Manager Connection Settings -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_listen_addresses = '*'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Host name or IP address for pcp process to listen on:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # '*' for all, '' for no TCP/IP connections</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_port = 9898</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Port number for pcp</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">pcp_socket_dir = '/var/run/postgresql'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Unix domain socket path for pcp</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # The Debian package defaults to</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # /var/run/postgresql</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Backend Connection Settings -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_hostname0 = '10.69.20.11'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Host name or IP address to connect to for backend 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_port0 = 5432</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Port number for backend 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_weight0 = 1</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Weight for backend 0 (only in load balancing mode)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_data_directory0 = '/var/lib/pgsql/9.5/data'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Data directory for backend 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_flag0 = 'ALLOW_TO_FAILOVER'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Controls various backend behavior</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_hostname1 = '10.68.20.11'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_port1 = 5432</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_weight1 = 1</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_data_directory1 = '/var/lib/pgsql/9.5/data'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">backend_flag1 = 'ALLOW_TO_FAILOVER'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># POOLS</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Concurrent session and pool size -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">num_init_children = 32</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Number of concurrent sessions allowed</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">max_pool = 4</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Number of connection pool caches per connection</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Life time -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">child_life_time = 300</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Pool exits after being idle for this many seconds</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">child_max_connections = 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Pool exits after receiving that many connections</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # 0 means no exit</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connection_life_time = 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Connection to backend closes after being idle for this many seconds</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # 0 means no close</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">client_idle_limit = 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Client is disconnected after being idle for that many seconds</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (even inside an explicit transactions!)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # 0 means no disconnection</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># CONNECTION POOLING</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connection_cache = on</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Activate connection pools</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Semicolon separated list of queries</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # to be issued at the end of a session</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # The default is for 8.3 and later</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">reset_query_list = 'ABORT; DISCARD ALL'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # The following one is for 8.2 and before</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># LOAD BALANCING MODE</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">load_balance_mode = on</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Activate load balancing mode</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">ignore_leading_white_space = on</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Ignore leading white spaces of each query</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">white_function_list = ''</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Comma separated list of function names</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # that don't write to database</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Regexp are accepted</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#black_function_list = 'nextval,setval,nextval,setval'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">black_function_list = 'currval,lastval,nextval,setval'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Comma separated list of function names</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # that write to database</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Regexp are accepted</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">database_redirect_preference_list = ''</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # comma separated list of pairs of database and node id.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # valid for streaming replicaton mode only.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">app_name_redirect_preference_list = ''</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # comma separated list of pairs of app name and node id.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # valid for streaming replicaton mode only.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">allow_sql_comments = off</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # if on, ignore SQL comments when judging if load balance or</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # query cache is possible.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # If off, SQL comments effectively prevent the judgment</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (pre 3.4 behavior).</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># MASTER/SLAVE MODE</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">master_slave_mode = on</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Activate master/slave mode</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">master_slave_sub_mode = 'stream'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Master/slave sub mode</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Valid values are combinations slony or</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # stream. Default is slony.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # (change requires restart)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Streaming -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_period = 5</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Streaming replication check period</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Disabled (0) by default</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_user = 'postgres'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Streaming replication check user</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # This is necessary even if you disable</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # streaming replication delay check with</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # sr_check_period = 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_password = 'xxxxxxxxxxxxxxxx'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Password for streaming replication check user</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">sr_check_database = 'postgres'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Database name for streaming replication check</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">delay_threshold = 10000000</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Threshold before not dispatching query to standby node</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Unit is in bytes</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Disabled (0) by default</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># - Special commands -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">follow_master_command = ''</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Executes this command after master failover</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Special values:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %d = node id</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %h = host name</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %p = port number</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %D = database cluster path</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %m = new master node id</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %H = hostname of the new master node</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %M = old master node id</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %P = old primary node id</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %r = new master port number</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %R = new master database cluster path</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # %% = '%' character</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""># HEALTH CHECK</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">#------------------------------------------------------------------------------</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_period = 40</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Health check period</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Disabled (0) by default</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_timeout = 10</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Health check timeout</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # 0 means no timeout</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_user = 'postgres'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Health check user</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_password = 'xxxxxxxxxxxxxxxxxx'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Password for health check user</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_database = ''</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Database name for health check. If '', tries 'postgres' frist, then 'template1'</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_max_retries = 3</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Maximum number of times to retry a failed health check before giving up.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">health_check_retry_delay = 1</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Amount of time to wait (in seconds) between retries.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">connect_timeout = 10000</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Timeout value in milliseconds before giving up to connect to backend.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Default is 10000 ms (10 second). Flaky network user may want to increase</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # the value. 0 means no timeout.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # Note that this value is not only used for health check,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> # but also for ordinary conection to backend.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Thanks.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#888888">Dylan</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:108.0pt">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#888888"> </span><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:72.0pt">
<br>
_______________________________________________<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/listinfo/pgpool-general</a><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<b><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#444444">Joffrey DUPIRE</span></b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#666666">Network Guru</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<img border="0" width="200" height="39" id="m_4245016435002446766_x005f_x0000_i1025" src="http://cobanking.fr/wp-content/uploads/2016/06/Gif_Signature_Morning.gif"><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.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><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-left:36.0pt">-- <o:p></o:p></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><o:p></o:p></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><o:p></o:p></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"><o:p></o:p></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"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><img border="0" width="200" height="39" id="_x0000_i1026" src="http://cobanking.fr/wp-content/uploads/2016/06/Gif_Signature_Morning.gif"><o:p></o:p></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><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>