<html><head></head><body><div class="ydp26c5aa13yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div dir="ltr" data-setdir="false">if you don't drop the replication slot, then the primary will accumulate the wal and the risk is a disk full. That's the difficulty about replication slots, it is a good feature but you need to monitor them. If you drop the replication slot, then you will probably have to rebuild the standby when it comes back, since there is a risk that not all wal will still be available on the primary.<br></div><div><br></div><div class="ydp26c5aa13signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydpb79b4ab9yahoo_quoted_1470071946" class="ydpb79b4ab9yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, June 5, 2020, 8:54:41 AM GMT+2, Anssi Kanninen <anssi@iki.fi> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Hi,<br clear="none"><br clear="none">Thank you for the answer, Pierre! I'll try that also.<br clear="none"><br clear="none">Is there any downside on not dropping the replication slots at all? If I <br clear="none">create them once on the primary and let them be there until other node is <br clear="none">promoted as primary?<br clear="none"><br clear="none">Cheers,<br clear="none"> - Anssi<br clear="none"><br clear="none">On Fri, 5 Jun 2020, Pierre Timmermans wrote:<br clear="none"><br clear="none">> Hi<br clear="none">> <br clear="none">> Another solution is to change the startup script of pgpool so that the start of pgpool is<br clear="none">> delayed until all the databases are up. So loop trying to connect to each backend database<br clear="none">> until success, with a max timeout<br clear="none">> <br clear="none">> <br clear="none">> Pierre<br clear="none">> <br clear="none">> <br clear="none">> On Friday, June 5, 2020, 1:57:40 AM GMT+2, Tatsuo Ishii <<a shape="rect" href="mailto:ishii@sraoss.co.jp" rel="nofollow" target="_blank">ishii@sraoss.co.jp</a>> wrote:<br clear="none">> <br clear="none">> <br clear="none">> >> 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><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">> <br clear="none">><br clear="none"><br clear="none">-- <br clear="none"><a shape="rect" href="mailto:anssi@iki.fi" rel="nofollow" target="_blank">anssi@iki.fi</a><div class="ydpb79b4ab9yqt1066321785" id="ydpb79b4ab9yqtfd88765"><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>