<html><head></head><body><div class="ydp4bc09265yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div dir="ltr" data-setdir="false">If you have the archived wals, then yes I think it is possible to resynchronize the standby database using the archives. But I guess it will not be out-of-the-box, maybe you'll need to copy the archived WAL to the standby so that it can consume them to catch-up with the primary ? It is worth experimenting.&nbsp;</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Also in the past I looked at a tool called barman, it can be very helpful (<a href="https://www.pgbarman.org/" rel="nofollow" target="_blank" class="">https://www.pgbarman.org/</a>)</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I am not using postgres for the moment so I don't know the latest technologies and I am not the best person to respond !<br><div><br></div></div><div class="ydp4bc09265signature">Pierre</div></div>
        <div><br></div><div><br></div>
        
        </div><div id="ydp9196baeyahoo_quoted_1944164544" class="ydp9196baeyahoo_quoted">
            <div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
                
                <div>
                    On Friday, June 5, 2020, 01:28:02 PM GMT+2, Anssi Kanninen &lt;anssi@iki.fi&gt; wrote:
                </div>
                <div><br></div>
                <div><br></div>
                <div><div dir="ltr">Thanks again for valuable advice to this novice. :-)<br clear="none"><br clear="none">If I use continous archiving (for point-in-time decovery) anyway, this <br clear="none">does not matter so much does it?<br clear="none"><br clear="none">Cheers,<br clear="none">&nbsp;  - Anssi<br clear="none"><br clear="none">On Fri, 5 Jun 2020, Pierre Timmermans wrote:<br clear="none"><br clear="none">&gt; if you don't drop the replication slot, then the primary will accumulate the wal and the<br clear="none">&gt; risk is a disk full. That's the difficulty about replication slots, it is a good feature<br clear="none">&gt; but you need to monitor them. If you drop the replication slot, then you will probably have<br clear="none">&gt; to rebuild the standby when it comes back, since there is a risk that not all wal will<br clear="none">&gt; still be available on the primary.<br clear="none">&gt; <br clear="none">&gt; Pierre<br clear="none">&gt; <br clear="none">&gt; <br clear="none">&gt; On Friday, June 5, 2020, 8:54:41 AM GMT+2, Anssi Kanninen &lt;<a shape="rect" href="mailto:anssi@iki.fi" rel="nofollow" target="_blank">anssi@iki.fi</a>&gt; wrote:<br clear="none">&gt; <br clear="none">&gt; <br clear="none">&gt; Hi,<br clear="none">&gt; <br clear="none">&gt; Thank you for the answer, Pierre! I'll try that also.<br clear="none">&gt; <br clear="none">&gt; Is there any downside on not dropping the replication slots at all? If I<br clear="none">&gt; create them once on the primary and let them be there until other node is<br clear="none">&gt; promoted as primary?<br clear="none">&gt; <br clear="none">&gt; Cheers,<br clear="none">&gt; &nbsp; - Anssi<br clear="none">&gt; <br clear="none">&gt; On Fri, 5 Jun 2020, Pierre Timmermans wrote:<br clear="none">&gt; <br clear="none">&gt; &gt; Hi<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; Another solution is to change the startup script of pgpool so that the start of pgpool is<br clear="none">&gt; &gt; delayed until all the databases are up. So loop trying to connect to each backend<br clear="none">&gt; database<br clear="none">&gt; &gt; until success, with a max timeout<br clear="none">&gt; &gt;<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; Pierre<br clear="none">&gt; &gt;<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; On Friday, June 5, 2020, 1:57:40 AM GMT+2, Tatsuo Ishii &lt;<a shape="rect" href="mailto:ishii@sraoss.co.jp" rel="nofollow" target="_blank">ishii@sraoss.co.jp</a>&gt; wrote:<br clear="none">&gt; &gt;<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; &gt;&gt; There's a parameter called "auto_failback" which automatically<br clear="none">&gt; &gt; &gt;&gt; attaches a PostgreSQL standby node if it's safe. auto_failback is<br clear="none">&gt; &gt; &gt;&gt; available in 4.1 or later.<br clear="none">&gt; &gt; &gt;<br clear="none">&gt; &gt; &gt; Thank you again for quick answer!<br clear="none">&gt; &gt; &gt;<br clear="none">&gt; &gt; &gt; That works but requires some changes to the example failover.sh<br clear="none">&gt; &gt; &gt; -script. The replication slot is dropped if standby node goes down. So<br clear="none">&gt; &gt; &gt; to get auto_failback working, the replication slot must be recreated<br clear="none">&gt; &gt; &gt; or not to be dropped at all.<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; True. Peng, what do you think?<br clear="none">&gt; &gt;<br clear="none">&gt; &gt; Best regards,<br clear="none">&gt; &gt; --<br clear="none">&gt; &gt; Tatsuo Ishii<br clear="none">&gt; &gt; SRA OSS, Inc. Japan<br clear="none">&gt; &gt; 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">&gt; &gt; Japanese:<a shape="rect" href="http://www.sraoss.co.jp" rel="nofollow" target="_blank">http://www.sraoss.co.jp</a><br clear="none">&gt; &gt; _______________________________________________<br clear="none">&gt; &gt; pgpool-general mailing list<br clear="none">&gt; &gt; <a shape="rect" href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br clear="none">&gt; &gt; <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><div class="ydp9196baeyqt3051544829" id="ydp9196baeyqtfd27574"><br clear="none">&gt; &gt;<br clear="none">&gt; &gt;<br clear="none">&gt; <br clear="none">&gt; --<br clear="none">&gt; <a shape="rect" href="mailto:anssi@iki.fi" rel="nofollow" target="_blank">anssi@iki.fi</a><br clear="none">&gt; _______________________________________________<br clear="none">&gt; pgpool-general mailing list<br clear="none">&gt; <a shape="rect" href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br clear="none">&gt; <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">&gt; <br clear="none">&gt;<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></div><div class="ydp9196baeyqt3051544829" id="ydp9196baeyqtfd87306">_______________________________________________<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></body></html>