<div dir="ltr"><div>Wolf,</div><div>Do you mind sharing relevant configuration and version of pgpool you are using? Do you have more than one slave?</div><div><br></div>I have tried the following combinations:<div><br></div><div>backend_flag0 = 'ALWAYS_MASTER|DISALLOW_TO_FAILOVER'<br></div><div>backend_flag1 = 'DISALLOW_TO_FAILOVER'<br></div><div><br></div><div>
<span style="font-size:small;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">backend_flag0 = 'ALWAYS_MASTER'</span>
<br></div><div>
<span style="font-size:small;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">backend_flag1 = 'DISALLOW_TO_FAILOVER'</span>
<br></div><div><br></div><div>
<div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">backend_flag0 = 'ALWAYS_MASTER'</span><span> </span><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:small;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">backend_flag1 = 'ALLOW_TO_FAILOVER'</span><span> </span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span><br></span></div><div style="text-decoration-style:initial;text-decoration-color:initial">master_slave_mode = on<br></div><div style="text-decoration-style:initial;text-decoration-color:initial">master_slave_sub_mode = 'stream'<br></div><div style="text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="text-decoration-style:initial;text-decoration-color:initial">sr_check_period = 0 and default sr_check_period = 10<br></div><div style="text-decoration-style:initial;text-decoration-color:initial"><div>health_check_period = 0<br></div></div>
failover_command = ''<br></div><div>fail_over_on_backend_error = off and fail_over_on_backend_error = on<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jun 20, 2018 at 8:40 AM, Wolf Schwurack <span dir="ltr"><<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Yes it is possible I have all my Pgpool hosts setup that way. My setup is a streaming replica and I don't apply the failover.sh script. If the master goes down pgpool fails over to the standby in readonly mode. <br>
<br>
<br>
Wolfgang Schwurack<br>
Database/System Administrator<br>
Utah Education Network<br>
801-587-9444<br>
<a href="mailto:wolf@uen.org">wolf@uen.org</a><br>
<div><div class="h5"> <br>
<br>
<br>
On 6/19/18, 9:48 PM, "<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@<wbr>pgpool.net</a> on behalf of Bo Peng" <<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@<wbr>pgpool.net</a> on behalf of <a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br>
<br>
Which version of Pgpool-II do you use?<br>
It also happened by latest version of Pgpool-II 3.7.4?<br>
<br>
On Tue, 19 Jun 2018 20:00:58 -0700<br>
Andre Piwoni <<a href="mailto:apiwoni@webmd.net">apiwoni@webmd.net</a>> wrote:<br>
<br>
> I have been trying to figure how can I configure PgPool with one primary<br>
> and one hot-standby slave to route read-requests to hot-standby when<br>
> primary is down without any failover. Is it currently possible? Please<br>
> don't ask why.<br>
> <br>
> Thank you,<br>
> Andre Piwoni<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</div></div> ______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br>
<br>
</blockquote></div><br></div>