<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for the response, Tatsuo.</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Kind regards</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Ian</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Tatsuo Ishii <ishii@sraoss.co.jp><br>
<b>Sent:</b> 12 March 2024 09:09<br>
<b>To:</b> Ian van der Linde <ian@ivdl.co.za><br>
<b>Cc:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> Re: [pgpool-general: 9046] Running pcp_detach_node on a backend set to DISALLOW_TO_FAILOVER</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">> Good day<br>
> <br>
> We are currently running pgPool-II 4.4.2, and would like to be able to detach a node from an external failover manager. In order words, we would prefer to switch off pgPool's built in automatic failover, and instead handle it using other scripts (in this
case using EDB Enterprise Failover Manager). <br>
> <br>
> Due to this situation, we have set all the backend flags to DISALLOW_TO_FAILOVER, with the expectation that we can still manually set a backend status to down using pcp_detach_node. When we try to do this, however, we see the following message:<br>
> <br>
> pcp_detach_node -n 0 -h 127.0.0.1 -U pcpadmin<br>
> ERROR: degenerate backend request for node_id: 0 from pid [394] is canceled because failover is disallowed on the node<br>
> <br>
> Is there some way in which we can prevent any automatic failovers by pgPool but which allows us to run detach/attach/promote as we see fit?<br>
<br>
No, there's no way to do such a thing in pgpool.<br>
<br>
Best reagards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS LLC<br>
English: <a href="http://www.sraoss.co.jp/index_en/">http://www.sraoss.co.jp/index_en/</a><br>
Japanese:http://www.sraoss.co.jp<br>
</div>
</span></font></div>
</body>
</html>