<html><head></head><body><div class="ydp7456bb27yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div dir="ltr" data-setdir="false">Hi</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Another solution is to change the startup script of pgpool so that the start of pgpool is delayed until all the databases are up. So loop trying to connect to each backend database until success, with a max timeout<br></div><div dir="ltr" data-setdir="false"><br></div><br><div class="ydp7456bb27signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp4e2f4e81yahoo_quoted_1683775036" class="ydp4e2f4e81yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, June 5, 2020, 1:57:40 AM GMT+2, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">>> There's a parameter called "auto_failback" which automatically<br clear="none">>> attaches a PostgreSQL standby node if it's safe. auto_failback is<br clear="none">>> available in 4.1 or later.<br clear="none">> <br clear="none">> Thank you again for quick answer!<br clear="none">> <br clear="none">> That works but requires some changes to the example failover.sh<br clear="none">> -script. The replication slot is dropped if standby node goes down. So<br clear="none">> to get auto_failback working, the replication slot must be recreated<br clear="none">> or not to be dropped at all.<br clear="none"><br clear="none">True. Peng, what do you think?<br clear="none"><br clear="none">Best regards,<br clear="none">--<br clear="none">Tatsuo Ishii<br clear="none">SRA OSS, Inc. Japan<br clear="none">English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" rel="nofollow" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br clear="none">Japanese:<a shape="rect" href="http://www.sraoss.co.jp" rel="nofollow" target="_blank">http://www.sraoss.co.jp</a><div class="ydp4e2f4e81yqt6546224933" id="ydp4e2f4e81yqtfd76068"><br clear="none">_______________________________________________<br clear="none">pgpool-general mailing list<br clear="none"><a shape="rect" href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br clear="none"><a shape="rect" href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br clear="none"></div></div></div>
</div>
</div></body></html>