<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:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mv="http://macVmlSchemaUri" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (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:"Courier New";
panose-1:2 7 3 9 2 2 5 2 4 4;}
@font-face
{font-family:"Cambria Math";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Helvetica Neue";
panose-1:2 0 5 3 0 0 0 2 0 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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Courier;}
p.ydpe1f5c6e0yiv4459533418msonormal, li.ydpe1f5c6e0yiv4459533418msonormal, div.ydpe1f5c6e0yiv4459533418msonormal
{mso-style-name:ydpe1f5c6e0yiv4459533418msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body bgcolor="white" lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Thanks Pierre, but my understanding is that native mode is different from streaming replication. That in native mode, pgpool does the synchronization.
Is that not correct? That is what I am trying to do, have pgpool synchronize the servers.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">I have included the text from the documentation to show where I got idea from:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">The streaming replication mode can be used with PostgreSQL servers operating streaming replication. In this mode, PostgreSQL is responsible
for synchronizing databases. This mode is widely used and most recommended way to use Pgpool-II. Load balancing is possible in the mode. The sample configuration file is $prefix/etc/pgpool.conf.sample-stream.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">In the native replication mode, Pgpool-II is responsible for synchronizing databases. The advantage for the mode is the synchronization
is done in synchronous way: writing to the database does not return until all of PostgreSQL servers finish the write operation. Note, however, read snapshot control is not done and consistent visibility is not guaranteed in the mode. Load balancing is possible
in the mode. The sample configuration file $prefix/etc/pgpool.conf.sample-replication.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Thank,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Warren<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif;color:black">From:
</span></b><span style="font-family:"Calibri",sans-serif;color:black">Pierre Timmermans <ptim007@yahoo.com><br>
<b>Date: </b>Tuesday, 27 June 2017 at 21:13<br>
<b>To: </b>"Birnbaum, Warren (ETW)" <Warren.Birnbaum@nike.com>, "pgpool-general@pgpool.net" <pgpool-general@pgpool.net><br>
<b>Subject: </b><External>Re: [pgpool-general: 5595] Unused status problem<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif">if you want to do native replication (i.e postgres master/slave streaming replication), then you need this in the conf<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<pre>master_slave_mode =on<o:p></o:p></pre>
<pre>master_slave_sub_mode = 'stream'<o:p></o:p></pre>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif">and at the postgres level you must of course set-up the master/slave<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif">Also in your </span><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_hostname list you have specified two times the slave,
so remove the block backend_hostname2 since it is a duplicate of the backend_hostname1.</span><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif">Pierre<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:13.5pt;font-family:"Helvetica Neue",sans-serif">
<hr size="2" width="100%" align="center">
</span></div>
<div id="ydpe1f5c6e0yahoo_quoted_8881288183">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">On Tuesday, June 27, 2017, 3:21:52 PM GMT+2, Birnbaum, Warren (ETW) <Warren.Birnbaum@nike.com> wrote:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<div id="ydpe1f5c6e0yiv4459533418">
<div>
<div>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">Hello,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">I am trying to install pgpool-II. I have 2 servers both running postgres 9.4 and pgpool is running on one of the servers. I am
trying to do native replication. I cannot get the second server to work and it shows as unused.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">---------+---------------+------+--------+-----------+--------+------------+-------------------+-------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">0 | localhost | 5432 | up | 0.538462 | master | 0 | true | 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">1 | 192.168.33.10 | 5432 | unused | 0.230769 | slave | 0 | false | 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">I am not finding much concerning the unused status so I don’t quite know what to change.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">Thanks,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">Warren</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># ----------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># pgPool-II configuration file</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># ----------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># This file consists of lines of the form:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># name = value</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># Whitespace may be used. Comments are introduced with "#" anywhere on a line.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># The complete list of parameter names and allowed values can be found in the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># pgPool-II documentation.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># This file is read on server startup and when the server receives a SIGHUP</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># signal. If you edit the file on a running system, you have to SIGHUP the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># server for the changes to take effect, or use "pgpool reload". Some</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># parameters, which are marked below, require a server shutdown and restart to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># take effect.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># CONNECTIONS</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - pgpool Connection Settings -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">listen_addresses = '*'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address to listen on:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # '*' for all, '' for no TCP/IP connections</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">port = 9999</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">socket_dir = '/tmp'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Unix domain socket path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # The Debian package defaults to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # /var/run/postgresql</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">listen_backlog_multiplier = 2</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Set the backlog parameter of listen(2) to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# num_init_children * listen_backlog_multiplier.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">serialize_accept = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # whether to serialize accept() call to avoid thundering herd problem</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - pgpool Communication Manager Connection Settings -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">pcp_listen_addresses = '*'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address for pcp process to listen on:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # '*' for all, '' for no TCP/IP connections</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">pcp_port = 9898</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number for pcp</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">pcp_socket_dir = '/tmp'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Unix domain socket path for pcp</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # The Debian package defaults to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # /var/run/postgresql</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Backend Connection Settings -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address to connect to for backend 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number for backend 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Weight for backend 0 (only in load balancing mode)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Data directory for backend 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Controls various backend behavior</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Authentication -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">enable_pool_hba = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Use pool_hba.conf for client authentication</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">pool_passwd = 'pool_passwd'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # File name of pool_passwd for md5 authentication.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # "" disables pool_passwd.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">authentication_timeout = 60</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Delay in seconds to complete client authentication</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no timeout.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - SSL Connections -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">ssl = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Enable SSL support</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#ssl_key = './server.key'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Path to the SSL private key file</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#ssl_cert = './server.cert'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Path to the SSL public certificate file</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#ssl_ca_cert = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Path to a single PEM format file</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # containing CA root certificate(s)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#ssl_ca_cert_dir = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Directory containing CA root certificate(s)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># POOLS</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Concurrent session and pool size -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">num_init_children = 32</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Number of concurrent sessions allowed</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">max_pool = 4</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Number of connection pool caches per connection</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Life time -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">child_life_time = 300</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Pool exits after being idle for this many seconds</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">child_max_connections = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Pool exits after receiving that many connections</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no exit</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">connection_life_time = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Connection to backend closes after being idle for this many seconds</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no close</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">client_idle_limit = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Client is disconnected after being idle for that many seconds</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (even inside an explicit transactions!)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no disconnection</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># LOGS</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Where to log -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_destination = 'syslog'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Where to log</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Valid values are combinations of stderr,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # and syslog. Default to stderr.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - What to log -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_line_prefix = '%t: pid %p:'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_connections = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Log connections</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_hostname = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Hostname will be shown in ps status</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # and in logs if connections are logged</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_statement = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Log all statements</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_per_node_statement = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Log all statements</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # with node and backend informations</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_standby_delay = 'none'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Log standby delay</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Valid values are combinations of always,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # if_over_threshold, none</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Syslog specific -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">syslog_facility = 'LOCAL0'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Syslog local facility. Default to LOCAL0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">syslog_ident = 'pgpool'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Syslog program identification string</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Default to 'pgpool'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Debug -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_error_verbosity = 'TERSE'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">client_min_messages = 'debug5'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug5</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug4</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug3</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug2</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug1</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # log</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # notice</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # warning</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # error</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">log_min_messages = debug1 # values in order of decreasing detail:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug5</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug4</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug3</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug2</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # debug1</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # info</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # notice</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # warning</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # error</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # log</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # fatal</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # panic</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># FILE LOCATIONS</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">pid_file_name = '/var/run/pgpool/pgpool.pid'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # PID file name</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">logdir = '/tmp'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Directory of pgPool status file</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># CONNECTION POOLING</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">connection_cache = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Activate connection pools</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Semicolon separated list of queries</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # to be issued at the end of a session</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # The default is for 8.3 and later</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">reset_query_list = 'ABORT; DISCARD ALL'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # The following one is for 8.2 and before</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># REPLICATION MODE</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">replication_mode = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Activate replication mode</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">replicate_select = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Replicate SELECT statements</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # when in replication mode</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # replicate_select is higher priority than</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # load_balance_mode.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">insert_lock = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Automatically locks a dummy row or a table</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # with INSERT statements to keep SERIAL data</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # consistency</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Without SERIAL, no lock will be issued</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">lobj_lock_table = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # When rewriting lo_creat command in</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # replication mode, specify table name to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # lock</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Degenerate handling -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">replication_stop_on_mismatch = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # On disagreement with the packet kind</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # sent from backend, degenerate the node</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # which is most likely "minority"</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If off, just force to exit this session</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">failover_if_affected_tuples_mismatch = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # On disagreement with the number of affected</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # tuples in UPDATE/DELETE queries, then</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # degenerate the node which is most likely</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # "minority".</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If off, just abort the transaction to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # keep the consistency</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># LOAD BALANCING MODE</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">load_balance_mode = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Activate load balancing mode</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">ignore_leading_white_space = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Ignore leading white spaces of each query</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">white_function_list = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Comma separated list of function names</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # that don't write to database</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Regexp are accepted</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">black_function_list = 'nextval,setval'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Comma separated list of function names</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # that write to database</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Regexp are accepted</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">database_redirect_preference_list = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# comma separated list of pairs of database and node id.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# valid for streaming replicaton mode only.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">app_name_redirect_preference_list = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# comma separated list of pairs of app name and node id.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# valid for streaming replicaton mode only.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">allow_sql_comments = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# if on, ignore SQL comments when judging if load balance or</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# query cache is possible.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# If off, SQL comments effectively prevent the judgment</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# (pre 3.4 behavior).</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># MASTER/SLAVE MODE</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">master_slave_mode = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Activate master/slave mode</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">master_slave_sub_mode = 'slony'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Master/slave sub mode</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Valid values are combinations slony or</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # stream. Default is slony.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Streaming -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">sr_check_period = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Streaming replication check period</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Disabled (0) by default</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">sr_check_user = 'nobody'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Streaming replication check user</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # This is neccessary even if you disable streaming</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # replication delay check by sr_check_period = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">sr_check_password = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Password for streaming replication check user</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">sr_check_database = 'postgres'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Database name for streaming replication check</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">delay_threshold = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Threshold before not dispatching query to standby node</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Unit is in bytes</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Disabled (0) by default</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Special commands -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">follow_master_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes this command after master failover</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Special values:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %d = node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %h = host name</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %p = port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %D = database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %m = new master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %H = hostname of the new master node</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %M = old master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %P = old primary node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %r = new master port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %R = new master database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %% = '%' character</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># HEALTH CHECK</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_period = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Health check period</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Disabled (0) by default</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_timeout = 20</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Health check timeout</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no timeout</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_user = 'postgres'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Health check user</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_password = 'postgres'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Password for health check user</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_database = 'postgres'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Database name for health check. If '', tries 'postgres' frist,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_max_retries = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Maximum number of times to retry a failed health check before giving up.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">health_check_retry_delay = 1</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Amount of time to wait (in seconds) between retries.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">connect_timeout = 10000</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Timeout value in milliseconds before giving up to connect to backend.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Default is 10000 ms (10 second). Flaky network user may want to increase</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# the value. 0 means no timeout.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Note that this value is not only used for health check,</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# but also for ordinary conection to backend.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># FAILOVER AND FAILBACK</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">failover_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes this command at failover</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Special values:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %d = node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %h = host name</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %p = port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %D = database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %m = new master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %H = hostname of the new master node</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %M = old master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %P = old primary node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %r = new master port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %R = new master database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %% = '%' character</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">failback_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes this command at failback.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Special values:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %d = node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %h = host name</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %p = port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %D = database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %m = new master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %H = hostname of the new master node</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %M = old master node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %P = old primary node id</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %r = new master port number</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# %R = new master database cluster path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # %% = '%' character</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">fail_over_on_backend_error = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Initiates failover when reading/writing to the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # backend communication socket fails</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If set to off, pgpool will report an</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # error and disconnect the session.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">search_primary_node_timeout = 300</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Timeout in seconds to search for the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # primary node when a failover occurs.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no timeout, keep searching</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # for a primary node forever.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># ONLINE RECOVERY</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">recovery_user = 'nobody'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Online recovery user</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">recovery_password = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Online recovery password</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">recovery_1st_stage_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes a command in first stage</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">recovery_2nd_stage_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes a command in second stage</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">recovery_timeout = 90</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Timeout in seconds to wait for the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # recovering node's postmaster to start up</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no wait</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">client_idle_limit_in_recovery = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Client is disconnected after being idle</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # for that many seconds in the second stage</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # of online recovery</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no disconnection</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # -1 means immediate disconnection</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># WATCHDOG</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Enabling -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">use_watchdog = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Activates watchdog</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># -Connection to up stream servers -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">trusted_servers = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # trusted server list which are used</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # to confirm network connection</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (hostA,hostB,hostC,...)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">ping_path = '/bin'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # ping command path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Watchdog communication Settings -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_hostname = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address of this watchdog</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_port = 9000</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # port number for watchdog service</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_priority = 1</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# priority of this watchdog in leader election</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_authkey = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Authentication key for watchdog communication</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_ipc_socket_dir = '/tmp'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Unix domain socket path for watchdog IPC socket</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# The Debian package defaults to</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# /var/run/postgresql</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Virtual IP control Setting -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">delegate_IP = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # delegate IP address</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If this is empty, virtual IP never bring up.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">if_cmd_path = '/sbin'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # path to the directory where if_up/down_cmd exists</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">if_up_cmd = 'ip addr add $_IP_$/24 dev eth0 label eth0:0'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # startup delegate IP command</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">if_down_cmd = 'ip addr del $_IP_$/24 dev eth0'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # shutdown delegate IP command</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">arping_path = '/usr/sbin'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # arping command path</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">arping_cmd = 'arping -U $_IP_$ -w 1'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # arping command</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Behaivor on escalation Setting -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">clear_memqcache_on_escalation = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Clear all the query cache on shared memory</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # when standby pgpool escalate to active pgpool</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (= virtual IP holder).</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # This should be off if client connects to pgpool</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # not using virtual IP.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_escalation_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Executes this command at escalation on new active pgpool.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_de_escalation_command = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Executes this command when master pgpool resigns from being master.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Lifecheck Setting -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># -- common --</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# if any interface from the list is active the watchdog will</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# consider the network is fine</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# 'any' to enable monitoring on all interfaces except loopback</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# '' to disable monitoring</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_lifecheck_method = 'heartbeat'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Method of watchdog lifecheck ('heartbeat' or 'query' or 'external')</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_interval = 10</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # lifecheck interval (sec) > 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># -- heartbeat mode --</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_heartbeat_port = 9694</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number for receiving heartbeat signal</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_heartbeat_keepalive = 2</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Interval time of sending heartbeat signal (sec)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_heartbeat_deadtime = 30</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Deadtime interval for heartbeat signal (sec)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address of destination 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # for sending heartbeat signal.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number of destination 0 for sending</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # heartbeat signal. Usually this is the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # same as wd_heartbeat_port.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Name of NIC device (such like 'eth0')</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # used for sending/receiving heartbeat</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # signal to/from destination 0.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # This works only when this is not empty</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # and pgpool has root privilege.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#heartbeat_destination1 = 'host0_ip2'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#heartbeat_destination_port1 = 9694</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#heartbeat_device1 = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># -- query mode --</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_life_point = 3</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # lifecheck retry times</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_lifecheck_query = 'SELECT 1'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # lifecheck query to pgpool from watchdog</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_lifecheck_dbname = 'template1'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Database name connected for lifecheck</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_lifecheck_user = 'nobody'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # watchdog user monitoring pgpools in lifecheck</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">wd_lifecheck_password = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Password for watchdog user in lifecheck</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># - Other pgpool Connection Settings -</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_pgpool_hostname0 = 'host0'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Host name or IP address to connect to for other pgpool 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_pgpool_port0 = 5432</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number for othet pgpool 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_wd_port0 = 9000</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Port number for othet watchdog 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_pgpool_hostname1 = 'host1'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_pgpool_port1 = 5432</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#other_wd_port1 = 9000</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># OTHERS</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">relcache_expire = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Life time of relation cache in seconds.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # 0 means no cache expiration(the default).</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # The relation cache is used for cache the</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # query result against PostgreSQL system</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # catalog to obtain various information</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # including table structures or if it's a</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # temporary table or not. The cache is</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # maintained in a pgpool child local memory</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # and being kept as long as it survives.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If someone modify the table by using</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # ALTER TABLE or some such, the relcache is</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # not consistent anymore.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # For this purpose, cache_expiration</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # controls the life time of the cache.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">relcache_size = 256</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Number of relation cache</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # entry. If you see frequently:</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# "pool_search_relcache: cache replacement happend"</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# in the pgpool log, you might want to increate this number.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">check_temp_table = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If on, enable temporary table check in SELECT statements.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # This initiates queries against system catalog of primary/master</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# thus increases load of master.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# If you are absolutely sure that your system never uses temporary tables</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# and you want to save access to primary/master, you could turn this off.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Default is on.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">check_unlogged_table = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If on, enable unlogged table check in SELECT statements.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # This initiates queries against system catalog of primary/master</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # thus increases load of master.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # If you are absolutely sure that your system never uses unlogged tables</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # and you want to save access to primary/master, you could turn this off.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Default is on.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"># IN MEMORY QUERY MEMORY CACHE</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">#------------------------------------------------------------------------------</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memory_cache_enabled = off</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# If on, use the memory cache functionality, off by default</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_method = 'shmem'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Cache storage method. either 'shmem'(shared memory) or</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# 'memcached'. 'shmem' by default</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_memcached_host = 'localhost'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Memcached host name or IP address. Mandatory if</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# memqcache_method = 'memcached'.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Defaults to localhost.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_memcached_port = 11211</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Memcached port number. Mondatory if memqcache_method = 'memcached'.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Defaults to 11211.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_total_size = 67108864</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Total memory size in bytes for storing memory cache.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Mandatory if memqcache_method = 'shmem'.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Defaults to 64MB.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_max_num_cache = 1000000</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Total number of cache entries. Mandatory</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# if memqcache_method = 'shmem'.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Each cache entry consumes 48 bytes on shared memory.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Defaults to 1,000,000(45.8MB).</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_expire = 0</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Memory cache entry life time specified in seconds.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# 0 means infinite life time. 0 by default.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_auto_cache_invalidation = on</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# If on, invalidation of query cache is triggered by corresponding</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# DDL/DML/DCL(and memqcache_expire). If off, it is only triggered</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# by memqcache_expire. on by default.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_maxcache = 409600</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Maximum SELECT result size in bytes.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Must be smaller than memqcache_cache_block_size. Defaults to 400KB.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_cache_block_size = 1048576</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Defaults to 1MB.</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">memqcache_oiddir = '/var/log/pgpool/oiddir'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">
# Temporary work directory to record table oids</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # (change requires restart)</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">white_memqcache_table_list = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Comma separated list of table names to memcache</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # that don't write to database</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Regexp are accepted</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">black_memqcache_table_list = ''</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Comma separated list of table names not to memcache</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # that don't write to database</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> # Regexp are accepted</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_hostname0 = 'localhost'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_port0 = 5432</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_weight0 = .7</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_data_directory0 = '/var/lib/pgsql/9.4/data'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_flag0 = 'ALLOW_TO_FAILOVER'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_hostname1 = '192.168.33.10'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_port1 = 5432</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_weight1 = .3</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_data_directory1 = '/var/lib/pgsql/9.4/data'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_flag1 = 'ALLOW_TO_FAILOVER'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_hostname2 = '192.168.33.10'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_port2 = 5432</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_weight2 = .3</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_data_directory2 = '/var/lib/pgsql/9.4/data'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">backend_flag2 = 'ALLOW_TO_FAILOVER'</span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:11.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> </span><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"><o:p></o:p></span></p>
<p class="ydpe1f5c6e0yiv4459533418msonormal"><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A"> <o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica Neue",sans-serif;color:#26282A">_______________________________________________<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></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>