<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Bookman Old Style";
panose-1:2 5 6 4 5 5 5 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am trying to set up two pgpool servers to manage four backend postgres database servers (on 6 different virtual machines). The pgpool works fine, switching from active to standby (“escalating to master pgpool”) when I kill the pgpool
process on the active node. But if I use ‘shutdown –h now’ or power-off the active node, no escalation will happen, just saying [”xxx” has not send the heartbeat signal yet’]. Below is the log messages from the two pgpool servers:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any help is greatly appreciately!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Jian<o:p></o:p></p>
<p class="MsoNormal">p.s. BTW, I am using repmgr to manage the database replications and automatic failovers.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#### On Active Server (192.168.122.150)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:36: pid 2000: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.251:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:38: pid 2000: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.251:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">Broadcast message from root@postgresql-7<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> (/dev/pts/1) at 13:19 ...<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">The system is going down for halt NOW!<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">Connection to 192.168.122.150 closed by remote host.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">Connection to 192.168.122.150 closed.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#### On Standby Server (192.168.122.251)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:39: pid 1521: DEBUG: watchdog checking life check is ready<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:39: pid 1521: DETAIL: pgpool:1 at "192.168.122.150:9999" has not send the heartbeat signal yet<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:39: pid 1520: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.150:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:41: pid 1520: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.150:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:43: pid 1520: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.150:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">2015-06-14 13:19:45: pid 1520: DEBUG: watchdog heartbeat: send heartbeat signal to 192.168.122.150:9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal">############### Below is one of the pgpool.conf file <o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># ----------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># pgPool-II configuration file<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># ----------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># This file consists of lines of the form:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># name = value<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># Whitespace may be used. Comments are introduced with "#" anywhere on a line.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># The complete list of parameter names and allowed values can be found in the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># pgPool-II documentation.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># This file is read on server startup and when the server receives a SIGHUP<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># signal. If you edit the file on a running system, you have to SIGHUP the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># server for the changes to take effect, or use "pgpool reload". Some<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># parameters, which are marked below, require a server shutdown and restart to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># take effect.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># CONNECTIONS<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - pgpool Connection Settings -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">listen_addresses = '*'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address to listen on:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # '*' for all, '' for no TCP/IP connections<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">port = 9999<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">socket_dir = '/tmp'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Unix domain socket path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # The Debian package defaults to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # /var/run/postgresql<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">listen_backlog_multiplier = 2<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Set the backlog parameter of listen(2) to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # num_init_children * listen_backlog_multiplier.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - pgpool Communication Manager Connection Settings -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">pcp_listen_addresses = '*'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address for pcp process to listen on:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # '*' for all, '' for no TCP/IP connections<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">pcp_port = 9898<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number for pcp<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">pcp_socket_dir = '/tmp'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Unix domain socket path for pcp<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # The Debian package defaults to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # /var/run/postgresql<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Backend Connection Settings -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_hostname0 = '192.168.122.142'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address to connect to for backend 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_port0 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number for backend 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_weight0 = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Weight for backend 0 (only in load balancing mode)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_data_directory0 = '/var/lib/pgsql/9.4/data'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Data directory for backend 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_flag0 = 'ALLOW_TO_FAILOVER'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Controls various backend behavior<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_hostname1 = '192.168.122.23'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_port1 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_weight1 = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_data_directory1 = '/var/lib/pgsql/9.4/data'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_flag1 = 'ALLOW_TO_FAILOVER'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_hostname2 = '192.168.122.45'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_port2 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_weight2 = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_data_directory2 = '/var/lib/pgsql/9.4/data'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_flag2 = 'ALLOW_TO_FAILOVER'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_hostname3 = '192.168.122.50'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_port3 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_weight3 = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_data_directory3 = '/var/lib/pgsql/9.4/data'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">backend_flag3 = 'ALLOW_TO_FAILOVER'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Authentication -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">enable_pool_hba = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Use pool_hba.conf for client authentication<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">pool_passwd = 'pool_passwd'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # File name of pool_passwd for md5 authentication.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # "" disables pool_passwd.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">authentication_timeout = 60<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Delay in seconds to complete client authentication<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no timeout.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - SSL Connections -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">ssl = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Enable SSL support<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#ssl_key = './server.key'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Path to the SSL private key file<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#ssl_cert = './server.cert'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Path to the SSL public certificate file<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#ssl_ca_cert = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Path to a single PEM format file<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # containing CA root certificate(s)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#ssl_ca_cert_dir = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Directory containing CA root certificate(s)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># POOLS<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Pool size -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">num_init_children = 32<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Number of pools<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">max_pool = 4<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Number of connections per pool<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Life time -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">child_life_time = 300<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Pool exits after being idle for this many seconds<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">child_max_connections = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Pool exits after receiving that many connections<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no exit<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">connection_life_time = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Connection to backend closes after being idle for this many seconds<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no close<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">client_idle_limit = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Client is disconnected after being idle for that many seconds<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (even inside an explicit transactions!)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no disconnection<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># LOGS<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Where to log -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_destination = 'stderr'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Where to log<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Valid values are combinations of stderr,<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and syslog. Default to stderr.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - What to log -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_connections = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Log connections<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_hostname = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Hostname will be shown in ps status<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and in logs if connections are logged<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_statement = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Log all statements<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_per_node_statement = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Log all statements<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # with node and backend informations<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">log_standby_delay = 'none'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Log standby delay<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Valid values are combinations of always,<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # if_over_threshold, none<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Syslog specific -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">syslog_facility = 'LOCAL0'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Syslog local facility. Default to LOCAL0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">syslog_ident = 'pgpool'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Syslog program identification string<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Default to 'pgpool'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Debug -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">debug_level = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Debug message verbosity level<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no message, 1 or more mean verbose<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#log_error_verbosity = default # terse, default, or verbose messages<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#client_min_messages = notice # values in order of decreasing detail:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug5<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug4<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug3<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug2<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # log<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # notice<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # warning<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # error<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#log_min_messages = warning # values in order of decreasing detail:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug5<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug4<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug3<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug2<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # debug1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # info<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # notice<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # warning<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # error<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # log<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # fatal<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # panic<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># FILE LOCATIONS<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">pid_file_name = '/var/run/pgpool/pgpool.pid'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # PID file name<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">logdir = '/tmp'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Directory of pgPool status file<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># CONNECTION POOLING<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">connection_cache = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Activate connection pools<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Semicolon separated list of queries<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # to be issued at the end of a session<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # The default is for 8.3 and later<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">reset_query_list = 'ABORT; DISCARD ALL'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # The following one is for 8.2 and before<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># REPLICATION MODE<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">replication_mode = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Activate replication mode<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">replicate_select = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Replicate SELECT statements<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # when in replication mode<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # replicate_select is higher priority than<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # load_balance_mode.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">insert_lock = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Automatically locks a dummy row or a table<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # with INSERT statements to keep SERIAL data<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # consistency<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Without SERIAL, no lock will be issued<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">lobj_lock_table = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # When rewriting lo_creat command in<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # replication mode, specify table name to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # lock<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Degenerate handling -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">replication_stop_on_mismatch = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # On disagreement with the packet kind<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # sent from backend, degenerate the node<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # which is most likely "minority"<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If off, just force to exit this session<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">failover_if_affected_tuples_mismatch = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # On disagreement with the number of affected<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # tuples in UPDATE/DELETE queries, then<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # degenerate the node which is most likely<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # "minority".<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If off, just abort the transaction to<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # keep the consistency<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># LOAD BALANCING MODE<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">load_balance_mode = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Activate load balancing mode<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">ignore_leading_white_space = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Ignore leading white spaces of each query<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">white_function_list = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Comma separated list of function names<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # that don't write to database<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Regexp are accepted<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">black_function_list = 'currval,lastval,nextval,setval'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Comma separated list of function names<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # that write to database<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Regexp are accepted<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">database_redirect_preference_list = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # comma separated list of pairs of database and node id.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # valid for streaming replicaton mode only.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">app_name_redirect_preference_list = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # comma separated list of pairs of app name and node id.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # valid for streaming replicaton mode only.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">allow_sql_comments = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # if on, ignore SQL comments when judging if load balance or<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # query cache is possible.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If off, SQL comments effectively prevent the judgment<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (pre 3.4 behavior).<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># MASTER/SLAVE MODE<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">master_slave_mode = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Activate master/slave mode<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">master_slave_sub_mode = 'stream'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Master/slave sub mode<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Valid values are combinations slony or<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # stream. Default is slony.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Streaming -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">sr_check_period = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Streaming replication check period<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Disabled (0) by default<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">sr_check_user = 'pgpool'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Streaming replication check user<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # This is neccessary even if you disable streaming<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # replication delay check by sr_check_period = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">sr_check_password = 'xxx'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Password for streaming replication check user<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">delay_threshold = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Threshold before not dispatching query to standby node<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Unit is in bytes<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Disabled (0) by default<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Special commands -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#follow_master_command = '/etc/pgpool-II-94/follow_master.sh %d %M %h'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#follow_master_command = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes this command after master failover<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Special values:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %d = node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %h = host name<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %p = port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %D = database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %m = new master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %H = hostname of the new master node<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %M = old master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %P = old primary node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %r = new master port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %R = new master database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %% = '%' character<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># HEALTH CHECK<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_period = 10<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Health check period<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Disabled (0) by default<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_timeout = 20<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Health check timeout<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no timeout<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_user = 'pgpool'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Health check user<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_password = 'xxx’<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Password for health check user<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_max_retries = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Maximum number of times to retry a failed health check before giving up.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">health_check_retry_delay = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Amount of time to wait (in seconds) between retries.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">connect_timeout = 10000<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Timeout value in milliseconds before giving up to connect to backend.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Default is 10000 ms (10 second). Flaky network user may want to
increase<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # the value. 0 means no timeout.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Note that this value is not only used for health check,<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # but also for ordinary conection to backend.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># FAILOVER AND FAILBACK<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#failover_command = '/etc/pgpool-II-94/failover.sh1 %d %P %H %R'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#failover_command = '/etc/pgpool-II-94/failover.sh %d %H'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes this command at failover<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Special values:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %d = node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %h = host name<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %p = port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %D = database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %m = new master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %H = hostname of the new master node<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %M = old master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %P = old primary node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %r = new master port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %R = new master database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %% = '%' character<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">failback_command = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes this command at failback.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Special values:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %d = node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %h = host name<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %p = port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %D = database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %m = new master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %H = hostname of the new master node<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %M = old master node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %P = old primary node id<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %r = new master port number<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %R = new master database cluster path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # %% = '%' character<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">fail_over_on_backend_error = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Initiates failover when reading/writing to the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # backend communication socket fails<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If set to off, pgpool will report an<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # error and disconnect the session.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">search_primary_node_timeout = 10<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Timeout in seconds to search for the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # primary node when a failover occurs.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no timeout, keep searching<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # for a primary node forever.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># ONLINE RECOVERY<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">recovery_user = 'pgpool'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Online recovery user<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">recovery_password = 'vm3323'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Online recovery password<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">recovery_1st_stage_command = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes a command in first stage<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">recovery_2nd_stage_command = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes a command in second stage<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">recovery_timeout = 90<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Timeout in seconds to wait for the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # recovering node's postmaster to start up<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no wait<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">client_idle_limit_in_recovery = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Client is disconnected after being idle<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # for that many seconds in the second stage<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # of online recovery<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no disconnection<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # -1 means immediate disconnection<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># WATCHDOG<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Enabling -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">use_watchdog = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Activates watchdog<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># -Connection to up stream servers -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">trusted_servers = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # trusted server list which are used<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # to confirm network connection<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (hostA,hostB,hostC,...)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">ping_path = '/bin'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # ping command path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Watchdog communication Settings -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_hostname = '192.168.122.150'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address of this watchdog<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_port = 9000<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # port number for watchdog service<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_authkey = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Authentication key for watchdog communication<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Virtual IP control Setting -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">delegate_IP = '192.168.122.58'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # delegate IP address<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If this is empty, virtual IP never bring up. <o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">ifconfig_path = '/sbin'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # ifconfig command path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # startup delegate IP command<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">if_down_cmd = 'ifconfig eth0:0 down'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # shutdown delegate IP command<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">arping_path = '/usr/sbin' # arping command path<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">arping_cmd = 'arping -U $_IP_$ -w 1'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # arping command<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Behaivor on escalation Setting -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">clear_memqcache_on_escalation = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Clear all the query cache on shared memory<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # when standby pgpool escalate to active pgpool<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (= virtual IP holder).<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # This should be off if client connects to pgpool<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # not using virtual IP.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_escalation_command = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Executes this command at escalation on new active pgpool.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Lifecheck Setting - <o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># -- common --<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_lifecheck_method = 'heartbeat'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Method of watchdog lifecheck ('heartbeat' or 'query')<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#wd_interval = 10<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_interval = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # lifecheck interval (sec) > 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># -- heartbeat mode --<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_heartbeat_port = 9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number for receiving heartbeat signal<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_heartbeat_keepalive = 2<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Interval time of sending heartbeat signal (sec)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#wd_heartbeat_deadtime = 30<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_heartbeat_deadtime = 3<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Deadtime interval for heartbeat signal (sec)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">heartbeat_destination0 = '192.168.122.251'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address of destination 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # for sending heartbeat signal.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">heartbeat_destination_port0 = 9694 <o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number of destination 0 for sending<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # heartbeat signal. Usually this is the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # same as wd_heartbeat_port.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">heartbeat_device0 = 'eth0'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Name of NIC device (such like 'eth0')<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # used for sending/receiving heartbeat<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # signal to/from destination 0.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # This works only when this is not empty<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and pgpool has root privilege.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#heartbeat_destination1 = 'host0_ip2'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#heartbeat_destination_port1 = 9694<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#heartbeat_device1 = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># -- query mode --<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_life_point = 3<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # lifecheck retry times<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_lifecheck_query = 'SELECT 1'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # lifecheck query to pgpool from watchdog<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_lifecheck_dbname = 'template1'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Database name connected for lifecheck<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_lifecheck_user = 'nobody'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # watchdog user monitoring pgpools in lifecheck<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">wd_lifecheck_password = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Password for watchdog user in lifecheck<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># - Other pgpool Connection Settings -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">other_pgpool_hostname0 = '192.168.122.251'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Host name or IP address to connect to for other pgpool 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">other_pgpool_port0 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number for othet pgpool 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">other_wd_port0 = 9000<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Port number for othet watchdog 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#other_pgpool_hostname1 = 'host1'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#other_pgpool_port1 = 5432<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#other_wd_port1 = 9000<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># OTHERS<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">relcache_expire = 1<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Life time of relation cache in seconds.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means no cache expiration(the default).<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # The relation cache is used for cache the<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # query result against PostgreSQL system<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # catalog to obtain various information<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # including table structures or if it's a<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # temporary table or not. The cache is<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # maintained in a pgpool child local memory<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and being kept as long as it survives.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If someone modify the table by using<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # ALTER TABLE or some such, the relcache is<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # not consistent anymore.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # For this purpose, cache_expiration<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # controls the life time of the cache.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">relcache_size = 256<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Number of relation cache<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # entry. If you see frequently:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # "pool_search_relcache: cache replacement happend"<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # in the pgpool log, you might want to increate this number.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">check_temp_table = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If on, enable temporary table check in SELECT statements.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # This initiates queries against system catalog of primary/master<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # thus increases load of master.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If you are absolutely sure that your system never uses temporary
tables<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and you want to save access to primary/master, you could turn this
off.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Default is on.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">check_unlogged_table = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If on, enable unlogged table check in SELECT statements.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # This initiates queries against system catalog of primary/master<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # thus increases load of master.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If you are absolutely sure that your system never uses unlogged tables<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # and you want to save access to primary/master, you could turn this off.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Default is on.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"># IN MEMORY QUERY MEMORY CACHE<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">#------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memory_cache_enabled = off<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If on, use the memory cache functionality, off by default<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_method = 'shmem'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Cache storage method. either 'shmem'(shared memory) or<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 'memcached'. 'shmem' by default<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_memcached_host = '192.168.122.58'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Memcached host name or IP address. Mandatory if<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # memqcache_method = 'memcached'.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Defaults to localhost.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_memcached_port = 11211<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Memcached port number. Mondatory if memqcache_method = 'memcached'.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Defaults to 11211.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_total_size = 67108864<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Total memory size in bytes for storing memory cache.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Mandatory if memqcache_method = 'shmem'.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Defaults to 64MB.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_max_num_cache = 1000000<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Total number of cache entries. Mandatory<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # if memqcache_method = 'shmem'.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Each cache entry consumes 48 bytes on shared memory.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Defaults to 1,000,000(45.8MB).<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_expire = 0<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Memory cache entry life time specified in seconds.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # 0 means infinite life time. 0 by default.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_auto_cache_invalidation = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # If on, invalidation of query cache is triggered by corresponding<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # DDL/DML/DCL(and memqcache_expire). If off, it is only triggered<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # by memqcache_expire. on by default.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_maxcache = 409600<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Maximum SELECT result size in bytes.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Must be smaller than memqcache_cache_block_size. Defaults to 400KB.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_cache_block_size = 1048576<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Defaults to 1MB.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">memqcache_oiddir = '/var/log/pgpool/oiddir'<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Temporary work directory to record table oids<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # (change requires restart)<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">white_memqcache_table_list = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Comma separated list of table names to memcache<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # that don't write to database<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Regexp are accepted<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black">black_memqcache_table_list = ''<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Comma separated list of table names not to memcache<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # that don't write to database<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"> # Regexp are accepted<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Bookman Old Style","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions
presented in this e-mail are solely those of the author and do not necessarily represent those of Exelis Inc. The recipient should check this e-mail and any attachments for the presence of viruses. Exelis Inc. accepts no liability for any damage caused by
any virus transmitted by this e-mail. <br>
</font>
</body>
</html>