<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. </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 <anssi@iki.fi> 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"> - Anssi<br clear="none"><br clear="none">On Fri, 5 Jun 2020, Pierre Timmermans wrote:<br clear="none"><br clear="none">> if you don't drop the replication slot, then the primary will accumulate the wal and the<br clear="none">> risk is a disk full. That's the difficulty about replication slots, it is a good feature<br clear="none">> but you need to monitor them. If you drop the replication slot, then you will probably have<br clear="none">> to rebuild the standby when it comes back, since there is a risk that not all wal will<br clear="none">> still be available on the primary.<br clear="none">> <br clear="none">> Pierre<br clear="none">> <br clear="none">> <br clear="none">> On Friday, June 5, 2020, 8:54:41 AM GMT+2, Anssi Kanninen <<a shape="rect" href="mailto:anssi@iki.fi" rel="nofollow" target="_blank">anssi@iki.fi</a>> wrote:<br clear="none">> <br clear="none">> <br clear="none">> 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<br clear="none">> 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><div class="ydp9196baeyqt3051544829" id="ydp9196baeyqtfd27574"><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><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></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>