<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>Hi,</div><div><br></div><div><span>There are a lot of parameters and it is indeed difficult to choose the right combination :-), so I am not sure neither.<br></span></div><div><span></span><br></div><div>From my experiments, I see a difference if you set the flag DISALLOW_TO_FAILOVER versus ALLOW_TO_FAILOVER. <br></div><br><div>with ALLOW_TO_FAILOVER, when the postgres database comes down pgpool will be detach it from the pool. But when the database is started again it won't be re-attached so you will have to do it manually.<br></div><div><br></div><div><div><span><div>with DISALLOW_TO_FAILOVER you don't have this problem, in fact can not use the pcp_detach_node
functionality</div></span></div><div><span></span><br></div><div>So I believe setting DISALLOW_TO_FAILOVER is better in a single node set-up. I would also set fail_over_on_backend_error to no and health_check_period = 0 and failover_command = '' (empty string) and load_balance_mode = no</div><div><br></div><div>In a multi-node set-up, i found that having DISALLOW_TO_FAILOVER is not OK because then you cannot use pcp_detach (in case for example you would manually want to exclude one standby from the pool)<br></div><div><br></div><div><br></div><div>Regards,<br></div><span><div><br></div></span><br></div><div class="ydp8eb51177signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydpf56a8ac5yahoo_quoted_9926012903" class="ydpf56a8ac5yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, June 22, 2018, 5:53:19 PM GMT+2, Alexander Dorogensky <amazinglifetime@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpf56a8ac5yiv8399680806"><div dir="ltr"><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;">Hi,</div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;"><br></div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;">I'm running pgpool 3.6.10 with postgres 9.6.8 in a single node configuration. Currently fail_over_on_backend_error = on, <span style="font-size:small;background-color:rgb(255,255,255);text-decoration-color:initial;float:none;display:inline;">so I believe setting it to off will disable it?</span></div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-color:initial;float:none;display:inline;"><br></span></div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-color:initial;float:none;display:inline;">Do I also have to set backend_flag0 to DISALLOW_FAILOVER?</span></div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-color:initial;float:none;display:inline;"><br></span></div><div class="ydpf56a8ac5yiv8399680806gmail_default" style="font-family:monospace;"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-color:initial;float:none;display:inline;">Thanks</span></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></div></body></html>