<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<meta name="x_Generator" content="Microsoft Word 15 (filtered medium)">
<style>
<!--
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:x_link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
a:x_visited, span.x_MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
.x_MsoChpDefault
{}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="blue" vlink="#954F72">
<div class="x_WordSection1">
<p class="x_MsoNormal">Thank you Tatsuo.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">For question1, on pgpool FIRST startup, will it check automatically from all of the backends to find out who is the master pg server? And only when failover it will then use the youngest node id as master?</p>
<p class="x_MsoNormal"> </p>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="border:none; padding:0in"><b>From: </b><a href="mailto:ishii@sraoss.co.jp">Tatsuo Ishii</a><br>
<b>Sent: </b>Tuesday, July 4, 2017 3:56 PM<br>
<b>To: </b><a href="mailto:hiscal@outlook.com">hiscal@outlook.com</a><br>
<b>Cc: </b><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<b>Subject: </b>Re: [pgpool-general: 5603] About pgpool backend and failover-command</p>
</div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">> Hi, all<br>
> <br>
> Iʼm new to pgpool, I have two questions here, can anyone give some advises? Thanks a lot.<br>
<br>
Welcome to Pgpool-II world:-)<br>
<br>
> 1. I have two PostgreSQL server running as master and slave with streaming replication mode, so is it a MUST that the master PostgreSQL server should be defined as backend0 and slave as backend1?<br>
<br>
No. The master can be either backend0 or backend1.<br>
<br>
> 2. The failover command will touch a trigger file to the new master, but which account will pgpool to execute the command?<br>
<br>
The same account as pgpool process starts.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:http://www.sraoss.co.jp<br>
</div>
</span></font>
</body>
</html>